asked on

sql server 2000 + How to display date time to say January 22, 2003

Hi,

I need to pass date time to the convert function if I need to show in the format

Jan 22, 2003

How can I write this as convert function

CONVERT(CHAR(12),GETDATE(),??)

thanks
-anshu

SOLUTION

David Todd

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Amit

ASKER

Hi,

I don't know what is BOL. Could you please post the list as well as answer to this.

I assume CONVERT(CHAR(12),GETDATE(), 100) will show the time also

thanks
-anshu

David Todd

Hi,

Do you want the time?

BOL is SQL Books On Line.

<copy of ms page removed>
<angelIII, zone advisor>

David Todd

Hi AngelIII,

Sorry for that.

Cheers
David

ASKER CERTIFIED SOLUTION

dduser

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Shannon_Lowder

Here is the complete list of conversions you will want to do with datetimes to varchar:

Without century (yy) 	With century (yyyy) 	
Standard 	
Input/Output**
- 	0 or 100 (*) 	Default 	mon dd yyyy hh:miAM (or PM)
1 	101 	USA 	mm/dd/yy
2 	102 	ANSI 	yy.mm.dd
3 	103 	British/French 	dd/mm/yy
4 	104 	German 	dd.mm.yy
5 	105 	Italian 	dd-mm-yy
6 	106 	- 	dd mon yy
7 	107 	- 	Mon dd, yy
8 	108 	- 	hh:mm:ss
- 	9 or 109 (*) 	Default + milliseconds 	mon dd yyyy hh:mi:ss:mmmAM (or PM)
10 	110 	USA 	mm-dd-yy
11 	111 	JAPAN 	yy/mm/dd
12 	112 	ISO 	yymmdd
- 	13 or 113 (*) 	Europe default + milliseconds 	dd mon yyyy hh:mm:ss:mmm(24h)
14 	114 	- 	hh:mi:ss:mmm(24h)
- 	20 or 120 (*) 	ODBC canonical 	yyyy-mm-dd hh:mi:ss(24h)
- 	21 or 121 (*) 	ODBC canonical (with milliseconds) 	yyyy-mm-dd hh:mi:ss.mmm(24h)
- 	126(***) 	ISO8601 	yyyy-mm-dd Thh:mm:ss.mmm(no spaces)
- 	130* 	Hijri**** 	dd mon yyyy hh:mi:ss:mmmAM
- 	131* 	Hijri**** 	dd/mm/yy hh:mi:ss:mmmAM

Open in new window

SOLUTION

Shannon_Lowder

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial