How To Convert Date Format?

Question

0.00/5 (No votes)

See more:

SQL

SQL-Server

How to Convert this date format "20140415"(YYMMDD) in below date format
April'14.
This

Thannx.....

Posted 17-Mar-15 1:12am

Naveen Kumar Tiwari

Updated 17-Mar-15 1:31am

v3

Add a Solution

Comments

Er. Puneet Goel 17-Mar-15 7:16am

where you want to perform this conversion ? server side or client side ? Please provide full details.

Thanks7872 17-Mar-15 7:29am

See the tags. Sql is there.

Naveen Kumar Tiwari 17-Mar-15 7:34am

This Format (20140403) IN my sql server table and I want to select date IN this format(April'14)

3 solutions

Solution 2

Hi,

Check this...SQL Server Functions that helps to convert date and time values to and from string literals and other date and time formats.[^]

Hope this will help you.

Cheers

Posted 17-Mar-15 1:26am

Magic Wonder

Solution 3

Solution :

C#

DateTime dates = DateTime.ParseExact("20140415", "yyyyMMdd", CultureInfo.InvariantCulture)

Posted 17-Mar-15 1:31am

Er. Puneet Goel

Comments

CHill60 17-Mar-15 7:32am

That's not SQL. OP has not tagged C# anywhere

Er. Puneet Goel 17-Mar-15 7:34am

ohh...yes i just misssed that :) Thanks for correcting

Add a Solution

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

Saral S Stalin · Accepted Answer · 2015-03-17T01:25:00

Solution 1

SQL

SELECT CONVERT(varchar, CONVERT(date, '20140415'), 106)

This will give you '15 Apr 2014'.

You can figure out how to convert that to Apr'14.

Posted 17-Mar-15 1:25am

Saral S Stalin

How To Convert Date Format?

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

How To Convert Date Format?

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us