Date format issue - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Date format issue

Author

Topic

goodman2253
Yak Posting Veteran

88 Posts

Posted - 2012-02-22 : 06:11:23

Hi guys i am stuck with an issue and i want your help

I am getting date in format Mar 26 2010 10:05AM
but i want it in format

03/26/10 10:05 AM

goodman2253
Yak Posting Veteran

88 Posts

Posted - 2012-02-22 : 08:31:30

Basically t convert
Mar 26 2010 10:05AM ---> 03/26/10 10:05 AM

rajan.nithin
Starting Member

42 Posts

Posted - 2012-02-22 : 08:55:02

Try SELECT CONVERT(VARCHAR, GETDATE(), 22)

quote:
Originally posted by goodman2253

Hi guys i am stuck with an issue and i want your help

I am getting date in format Mar 26 2010 10:05AM
but i want it in format

03/26/10 10:05 AM

goodman2253
Yak Posting Veteran

88 Posts

Posted - 2012-02-22 : 09:23:29

Thanks..

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources