Hi all,
I have two columns OPEN_DATE (ex...2007-03-27) and OPEN_TIME (ex...15:20:54)
The time format I am required to display - mm/dd/yyyy hh:mm
I am using the below script

select ltrim(rtrim(char(month(open_date))))|| '/' ||ltrim(rtrim(char(day(open_date))))||'/'||ltrim(rtrim(char(year(open_date))))||' '||ltrim(rtrim(char(hour(open_time))))||':'||ltrim (rtrim(char(minute(open_time)))) from <table>

Result : 3/27/2007 15:20

The problem is how do I get the month as '03' instead of just '3'

Thanks in advance..

Instead of using month, day, year, etc functions, I would use the substr funciton of the date column for each of these.

db2 values char(date ('2007-03-27'),usa)
1
----------
03/27/2007

and then concat the time

Great.....Thanks!!!