How to getting the Required Date Format from sql server 2008

Question

0.00/5 (No votes)

See more:

I guys , i was tried different date formats but doesn't got the required Date Format.

I want the date format as : 01-Mar-2013 05:30:58 PM

Please any one help me.

Posted 1-Mar-13 1:01am

CH Guravaiah

Updated 1-Mar-13 1:02am

v3

Add a Solution

4 solutions

Solution 1

Hi,

refer below articles to more on SQL date formats.
SQL Server Date Formats[^]
CAST and CONVERT (Transact-SQL)[^]
SQL SERVER – Display Datetime in Specific Format [^]

pickup which suites best for your requirement.

hope it helps.

Posted 1-Mar-13 1:06am

Karthik Harve

Solution 3

visit this link

http://www.sql-server-helper.com/sql-server-2008/sql-server-2008-date-format.aspx[^]

Posted 1-Mar-13 1:16am

samadhan_kshirsagar

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

willington.d · Accepted Answer · 2013-03-01T01:15:00

Solution 2

SQL

SELECT REPLACE(CAST(convert(varchar, getdate(), 113) AS VARCHAR(11)), ' ','-') + ' ' + LTRIM(RIGHT(CONVERT(VARCHAR(30), GETDATE(), 109), 15))

Posted 1-Mar-13 1:15am

willington.d

Comments

gvprabu 1-Mar-13 7:48am

Your Output is coming Different, pls check

CH Guravaiah 1-Mar-13 7:52am

thanks for giving information. But here is 01-Mar-2013 6:19:58:380PM . from the date no need the Milliseconds. I want only 01-Mar-2013 05:30:58 PM these format. Please give me the correct Answer.

gvprabu · Accepted Answer · 2013-03-01T01:50:00

Solution 4

Hi ,

Check the following Query....

SQL

SELECT GETDATE(), REPLACE(CONVERT(varchar(30), GETDATE(),106),' ','-')+' ' + LTRIM(RIGHT(CONVERT(CHAR(20), GETDATE(), 22), 11))

Regards,
GVPrabu

Posted 1-Mar-13 1:50am

gvprabu

Updated 1-Mar-13 1:51am

v2

How to getting the Required Date Format from sql server 2008

4 solutions

Solution 2

Solution 4

Solution 1

Solution 3

Add your solution here

Preview 0

How to getting the Required Date Format from sql server 2008

4 solutions

Solution 2

Solution 4

Solution 1

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us