Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Dates

Author  Topic 

sambrown180
Starting Member

38 Posts

Posted - 2008-11-18 : 11:18:49
What data type is needed for dates? smalldatetime keeps the time section which i do not want.

i am then trying to run a query which will work out from date of births who is under 18. Any ideas which code will work out records which are under 18 i can only think of something along the lines of date of birth <18 years.

Please help.

Thanks

Sam

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-18 : 11:22:13
see this

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=64762
Go to Top of Page
   

- Advertisement -