SQL Server – Data Type Converions

Posted: August 3, 2011 in SQLServer
Tags: ,

Refer for all possible conversions @ http://msdn.microsoft.com/en-us/library/ms187928.aspx

Following one helps to extact date from datetime format ...

CONVERT(VARCHAR(10),GETDATE(),111)

Refer intersting article (4 parts) by Madhivanan @ http://beyondrelational.com/blogs/madhivanan/archive/2010/05/25/understanding-datetime-column-part-i.aspx

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s