want to change date format

ambesh · New User Joined: 07 Jul 2005 Posts: 6 Location: pune

hi
i can get date by current date but the format of date is yyyy-mm-dd and now i wish to change date format in dd-mm-yyyy

please tell me what query required .

thanks

withnams · New User Joined: 06 Jul 2005 Posts: 26 Location: Chennai

try to use DSN8.ALTDATE(input date, input format, output format) in your select statement.

Abirami.YN · Posted: Fri Jul 29, 2005 6:27 pm

HI ,

U can execute by

select char(date,format) from tablename

format is like usa

example:

select char(datecol,usa) from db2.sample