CODEWITHSUNDEEP
sqldb2
BlakBat
BlakBat

Reputation: 1853

Format date to string

I'm trying to format a db2 date into a string as "YYYY/MM/DD".

The best I got so far is:

SELECT CAST(YEAR(MYDATE) AS VARCHAR(4)) || '/'
|| CAST(MONTH(MYDATE) AS VARCHAR(2))    || '/'
|| RIGHT('00' || CAST(DAY(MYDATE) AS VARCHAR(2)), 2) FROM MYCALENDAR

Is there a better, terser way to do this?

ps: Toying around with locales is not an option.

Upvotes: 4

Views: 41871

Answers (1)

Dennis Traub
Dennis Traub

Reputation: 51634

According to the IBM documentation the following should work:

 SELECT VARCHAR_FORMAT(MYDATE, 'YYYY/MM/DD') FROM MYCALENDAR;

Upvotes: 14

Related Questions