How to join the separated date field

[tokita]

Hi guys,

I'm the begginer of DB2 user.
I have a really simple question, that is about the combinning date fields. There are Year field, Month field, and Day field. All of them are varchar data-types.
Then, I want to combine all of them, and creat the new serialYear type field. So I can put the some dayname thing on the other field as Monday, tuesday, so on.

Please let me know, if you know about this.

Uri

 

[sgursahaney]

You can concatenate them using the CONCAT function or the || operator. For example, to get the date in YYYYMMDD format, do the following:

SELECT YEAR_FIELD||MONTH_FIELD||DAY_FIELD FROM TABLE

An easier way to get a date formatted is to use the CHAR function:

SELECT CHAR(TIME_STAMP, USA) FROM TABLE

Hope that helps.

Regards,
Suresh

 

[tokita]

Thanks a lot, Suresh.
I'll try this way.

uri