Printable View
Hi
I have a table with a varchar column, and in that column there are date values in the format 'yyyy/mm/dd hi24mm'.
I am trying to run a query to co convert this into a date coulumn (Just to run different date functions and other functions like MAX) and I get an " Invalid number Error".
Does anyone have any Ideas ?
Pls Help
Thanx.
Hi,
the format is probably 'yyyy/mm/dd hh24mm' isn't it?
I suppose some of the values in the varchar column don't correspond to the format you expect.
Try to find it, perhaps it has different length.
Ales
Also ...
The minutes should be mi - not mm (month!).
Yes! It's friday, I'm almost blind ... ;)Quote:
Originally posted by JMac
The minutes should be mi - not mm (month!).
This could be the problem, If you have mm there every minute higher than 12 causes the error.
SQL> select to_date('1999/12/25 10:25','yyyy/mm/dd hh24:mi') tarry_tst from dual;
TARRY_TST
---------
25-DEC-99
CHEERS