Converting a date format in sybase

Question

I need to convert May 8 2014 to this format 08/05/2014.

I tried using:

convert(char(12),"May 8 2014",103)

but it did not work.

Kindly suggest a workaround.

*but it did not work* can you be more specific? What didn't work exactly, etc. — Tim, May 28 '14 at 06:59
Also beware of using DD/MM/YYYY for a date format as can easily come unstuck with US folks assuming its MM/DD/YYYY. — Rich Campbell, Dec 13 '17 at 13:25

Robert · Accepted Answer · 2014-05-28T11:50:05.247

2

Try to convert the string to datetime, and than you should convert it to char as below:

select convert(char(12),cast("May 8 2014" as datetime) ,103)

edited May 28 '14 at 11:50

answered May 28 '14 at 09:08

Robert

score 0 · Answer 2 · answered May 30 '14 at 01:25

0

Another implementation of same approach , i.e., first convert to datetime:

select convert(char(12),convert(datetime,"May 8 2014") ,103)

answered May 30 '14 at 01:25

crizzo

2 Answers2