how do we do date and time formats?

manth · #1 (**permalink**) 03-30-04, 13:12

Hi,

Here is my query and result

db2 => SELECT PUTDATE, COUNT(*) FROM DB2ADMIN.MQMDLOG WHERE PUTDATE BETWEEN '2004-03-29' AND '2004-03-30' GROUP BY PUTDATE

PUTDATE 2
---------- -----------
2004-03-29 9769
2004-03-30 5210

2 record(s) selected.

I want result like this

PUTDATE 2
---------- -----------
29/03/2004 9,769
30/03/2004 5,210

How do we get the above result??

I appreciate ur help?

Thanks

n_i · #2 (**permalink**) 03-30-04, 13:28

Quote:

Originally posted by manth

I want result like this

PUTDATE 2
---------- -----------
29/03/2004 9,769
30/03/2004 5,210

How do we get the above result??

Look up the CHAR() function in SQL Reference