Converting SQL DateTime to a Simple Date

By XeroCube | April 29, 2011

Just to remind myself at a later date, this is a SQL Query that shows how to strip the timestamp from a datetime value.

Declare @fulldate datetime

Set @fulldate = getdate()

Declare @shortdate smalldatetime

Set @shortdate = convert(datetime,convert(char(10),getdate(),101))

Select @fulldate, @shortdate

Topics: Code, SQL, Tech | No Comments »

Comments

Archives

Blogroll

RockinMedia