How to format a Date field

Niaz · June 23rd, 2003, 06:09 AM

How can I format a Date field in a SQL Server Table in any desired format such as (dd-mmm-yy) while querying with SQL Query Analyzer?

Jeff Mason · June 23rd, 2003, 06:20 AM

The data is always stored the same way, as either a datetime or smalldatetime data type.

You can convert this internal representation to a character datatype by using either the CAST or CONVERT functions. For example:

Code:

SELECT CONVERT(varchar(10),yourdatetimecolumn,101) as Yourdateasvarchar
FROM ...

will return a 10 character string representation of the date as mm/dd/yyyy. See BOL for other values of the 'style' parameter of the CONVERT function.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

defiant · June 25th, 2003, 12:43 AM

you can configure sql query analyzer to use a certain date / time format when converting datetime or smalldatetime data to string for displaying on the results pane like this: go to menu tools / options then on the connections tab check use regional settings....

the regional settings you can view / change from the control panel.

defiant.