Viewing post 1 (of 1 total)
Hi,
Try this... convert(varchar,cast(thisdate as datetime),6)
thisdate is the date u want to convert.
example: select convert(varchar,cast('2003-04-09 00:00:00.000' as datetime),6) will print
09 Apr 03
Hope this will solve ur problem,
Happy Programming
Gopal
May 26, 2003 at 3:03 am
Viewing post 1 (of 1 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy