CodePaste.NET - Trim date

Subscribe

Discuss

What's new

What is it

New Snippet

Recent Snippets

Recent Snippets

My Snippets

My Snippets

Web Code

Search Snippets

Search

Sign inor Register

Language: SQL

Trim date

254 Views

Copy Code

Show/Hide Line Numbers

SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE())) 
select convert(varchar(10),getdate(),121)
CONVERT(VARCHAR,start_dttm,111)

by Stefan Sandström
February 23, 2010 @ 12:42am

Tags:

Add a comment

Report Abuse

brought to you by:

West Wind Techologies

If you find this site useful and use it frequently please consider making a donation to support this free service.

Donate