Text to date format in sql

Question

How can i convert the table containing date in text format DY Mon DD YYYY into DD MM YY date format which can be used for sorting when exported to a spread sheet.

The first date format is "Sun Jan 6 2013" which needs to be converted to "06-Jan-13" to be in date format not text which can be sorted on spread sheet and the type of the column is Text.

Thanks in advance.

please provide an example of your first date format DY Mon DD YYYY — sailingthoms
– sailingthoms, Commented Jan 1, 2014 at 13:59
the first date format is "Sun Jan 6 2013" which needs to be converted to "06-Jan-13" to be in date format not text which can be sorted on spread sheet and the type of the column is Text. — user3139623
– user3139623, Commented Jan 1, 2014 at 14:01

Mureinik · Accepted Answer · 2014-01-01 14:04:38Z

2

You can convert the text you have to a DATE value, and then re-format it:

SELECT TO_CHAR(TO_DATE(date_column, 'DY MON DD YYYY'), 'DD MM YY')
FROM   my_table

answered Jan 1, 2014 at 14:04

Mureinik

316k54 gold badges402 silver badges406 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user3139623 Over a year ago

Just to clarify i was using this earlier, however the output was in text format which didn't enable me to sort date on excel.

Mureinik Over a year ago

@user3139623 In Excel, just format it as date with this format and you should be good to go.

Collectives™ on Stack Overflow

Text to date format in sql

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related