How to get the perticular Date Format from Sql server

Question

1.00/5 (1 vote)

See more:

Hi guys, I was tried my requirement. But I want Date format like this : 25-Mar-2013.

Actually it was done by requirement using this :

Select REPLACE(CONVERT(VARCHAR,STARTDATE,106),' ','-')

But Here it can converting into string format.

Same format(25-Mar-2013) i will be convert into Date Format

Please any one help me...

Posted 24-Mar-13 21:51pm

CH Guravaiah

Updated 24-Mar-13 23:54pm

v4

Add a Solution

2 solutions

Add a Solution

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

Member 9762654 · Answer 1 · 2013-03-24T22:17:00

Solution 1

use

SQL

CAST( CONVERT(VARCHAR(10), startdate, 105) AS date)

Posted 24-Mar-13 22:17pm

Member 9762654

Updated 25-Mar-13 0:10am

v3

Comments

CH Guravaiah 25-Mar-13 4:50am

if it is executed , getting the like this : 2013-03-25 00:00:00.000

But i want 25-Mar-2013

Member 9762654 25-Mar-13 5:36am

use date instead of datetime check my updated solution again

CH Guravaiah 25-Mar-13 5:51am

Datetime also 2013-03-25 00:00:00.000

Member 9762654 25-Mar-13 7:23am

have you solved?

Member 9762654 25-Mar-13 6:11am

CAST( CONVERT(VARCHAR(10), startdate, 105) AS date) check solution

vinodkumarnie · Answer 2 · 2013-03-24T22:28:00

Solution 2

Try below link...

http://stackoverflow.com/questions/4011696/convert-datetime-in-sql-server[^]

Posted 24-Mar-13 22:28pm

vinodkumarnie

Comments

vinodkumarnie 25-Mar-13 5:21am

didn't you got answer..?

CH Guravaiah 25-Mar-13 5:53am

yes. please put the related answer. exactly same format like 25-Mar-2013 and it should be return the Date format only , not for Varchar like that.

vinodkumarnie 25-Mar-13 5:59am

U can't expect spoon feeding yet.. Hope you got it..?

How to get the perticular Date Format from Sql server

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

How to get the perticular Date Format from Sql server

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us