Feb
13
2008

Extract date from getdate(): the easier version

select convert(varchar(10), getdate(), 101)

You’ll get mm/dd/yyyy

Learn more from http://msdn2.microsoft.com/en-us/library/ms187928.aspx

Written by hkai in: SQL Server 2005 |

No Comments »

RSS feed for comments on this post. TrackBack URL

Leave a comment

*
To prove that you're not a bot, enter this code
Anti-Spam Image

Powered by WordPress | Aeros Theme | TheBuckmaker.com WordPress Themes