sudal2000

 Profile Answers by sudal2000 

• Jun 12th, 2006

 

hai,

          using this query you can take as you like,

           select convert(varchar,DATE,107) from tablename

            DATE->one of the column is availabe in table which is created by you

rick

• Jun 24th, 2006

 

CREATE TABLE mytable ([Date] SMALLDATETIME)

Yogesh Srivastava

• Jun 27th, 2006

 

Hi

Your can try this

SELECT  CONVERT(varchar, GETDATE(), 103)

In this example the GETDATE() will return your sql server system date.

and  the CONVERT is used to convert the date into the desired fomat.

Basically the CONVERT requires three arguments

1. Datatype

2. Date to Convert

3. Format style

Here is the list of style .....

Style ID	Style Type
0 or 100	mon dd yyyy hh:miAM (or 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:mm:ss
9 or 109	mon dd yyyy hh:mi:ss:mmmAM (or PM)
110	mm-dd-yy
111	yy/mm/dd
112	yymmdd
13 or 113	dd mon yyyy hh:mm:ss:mmm(24h)
114	hh:mi:ss:mmm(24h)
20 or 120	yyyy-mm-dd hh:mi:ss(24h)
21 or 121	yyyy-mm-dd hh:mi:ss.mmm(24h)
126	yyyy-mm-dd Thh:mm:ss.mmm(no spaces)
130	dd mon yyyy hh:mi:ss:mmmAM
131	dd/mm/yy hh:mi:ss:mmmAM

Enjoy the Code...

Hope this will help u