Hi,
I need to convert one date format to another. I am using the following query but is not working, can someone suggest the reson for the query not to work.
select TO_CHAR(trans_d ate,'YYYY-MM-DD HH24:MI:SS') as trans_date from ln_si_addr_ex_s upport
User Profile
Collapse
-
Conversion of date format
Hi,
i need to convert a date into another date format but when i use TO_CHAR or TO_DATE key word to convert the date format the error given is:-
Error starting at line 1 in command:
update ln_si_addr_ex_s upport set trans_date = to_date('03:50: 53 11 Jun 2007','YYYY-mm-DD HH24:MI:SS')
Error report:
SQL Error: ORA-01843: not a valid month
01843. 00000 - "not a valid month"
No activity results to display
Show More
Leave a comment: