DB2 date functions

praveenp4u · New User Joined: 07 Mar 2005 Posts: 1

Hi All,

can u pls tell me how char function works.
what are the different format?

is the char function have two parameters
eg: char(current date,start_date)

if so pls explain the same.

Advance thanks for the reply!!!!!!!!

ovreddy · Posted: Fri May 20, 2005 2:21 pm

Hi Praveen,

CHAR function is used to convert various types of data like numbers, date and time to character data.

To convert date or time to character type we need to use 2 arguments as folloows...

CHAR(date/time,'format');

The second argument specifies the format of the date to be converted.

Thanks,
Reddy.