Advanced Search

Return to Snippet

Revision: 20014
at November 4, 2009 14:31 by highlyevolved
Initial Code 
CONVERT(VARCHAR(10), "Enter Date/time field/parameter", "format type")

Example: CONVERT(VARCHAR(10), GETDATE(), 101)


Formats:

"101" selects Date
"108" selects Time
Initial URL 









Initial Description





These statements convert a date/time field into just a date or a time field









Initial Title





Convert Date/Time in SQL









Initial Tags





sql, date, convert









Initial Language





SQL