I have a field named expire_dt. It's a char(10). For example:
EXPIRE_DT
----------
2002-08-31
2002-08-31
How to convert that to this:
Aug/31/01
Thanks
Qingbo
Printable View
I have a field named expire_dt. It's a char(10). For example:
EXPIRE_DT
----------
2002-08-31
2002-08-31
How to convert that to this:
Aug/31/01
Thanks
Qingbo
Hi
If u want to display in the req format
it is To_char(column_name ,'mon/dd/yy')
Thanks
lnr
select to_char(sysdate,'Mon/DD/YY') from dual;
If your column is CHAR type then you will have to convert that to DATE form before using to_char function. So your query will be more likely as follows --
select to_char(to_date(expire_dt, 'yyyy-mm-dd'), 'Mon/dd/yy') from dual;
- Rajeev