to date problem
-
hi, sorry for second time writing actually i missing one line to tell you. in my windows application users enters theirs dateofbirth details like 02/05/1983.and my problem is i want show the Date of births between specified month and date values.i am using sqlserver 2005 as backend.but in that todate function is not there. 'Select Convert(datetime ,'2002/01/01') ' this function gives us entire date but i want retrive the DD/MM only from specified date. in oracle we have to date('DD/MM','02/05/1983') but in sql server it was not working please help me in this problem. thank you. regards
-
hi, sorry for second time writing actually i missing one line to tell you. in my windows application users enters theirs dateofbirth details like 02/05/1983.and my problem is i want show the Date of births between specified month and date values.i am using sqlserver 2005 as backend.but in that todate function is not there. 'Select Convert(datetime ,'2002/01/01') ' this function gives us entire date but i want retrive the DD/MM only from specified date. in oracle we have to date('DD/MM','02/05/1983') but in sql server it was not working please help me in this problem. thank you. regards
Please don't start a new thread for a follow-up comment to your original question[^].
Scott. —In just two days, tomorrow will be yesterday. —Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai
[Forum Guidelines] [Articles] [Blog]