-
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!).
-
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.
-
SQL> select to_date('1999/12/25 10:25','yyyy/mm/dd hh24:mi') tarry_tst from dual;
TARRY_TST
---------
25-DEC-99
CHEERS
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|