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
Active User
Joined: 06 Dec 2004
Posts: 200
Location: Keane India Ltd., Hyderabad
|
|
|
|
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. |
|
