Date Conversions
Sybase and Microsoft's SQL Server can insert dates into a table in various formats; they can also extract dates in several different types of formats. This section shows you how to use SQL Server's CONVERT command to manipulate the way a date is displayed.
CONVERT (datatype [(length)], expression, format)
The following date formats are available with SQL Server when using the CONVERT function:
Format Code | Format Picture |
---|---|
100 | mon dd yyyy hh:miAM/PM |
101 | mm/dd/yy |
102 | yy.mm.dd |
103 | dd/mm/yy |
104 | dd.mm.yy |
105 | dd-mm-yy |
106 | dd mon yy |
107 | mon dd, yy |
108 | hh:mi:ss |
109 | mon dd, yyyy hh:mi:ss:mmmAM/PM |
110 | mm-dd-yy |
111 | yy/mm/dd |
112 | yymmdd |
select "PayDate" = convert(char(15), paydate, 107) from payment_table where customer_id = 012845 PayDate --------------- May 1, 97 ...
Get Sams Teach Yourself SQL in 21 Days, Fourth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.