Date Fuctions

[clarence]

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.

[ales]

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

[JMac]

Also ...
The minutes should be mi - not mm (month!).

[ales]

Originally posted by JMac
The minutes should be mi - not mm (month!).

Yes! It's friday, I'm almost blind ...
This could be the problem, If you have mm there every minute higher than 12 causes the error.

[Tarry]

SQL> select to_date('1999/12/25 10:25','yyyy/mm/dd hh24:mi') tarry_tst from dual;

TARRY_TST
---------
25-DEC-99


CHEERS