Re: ORA-01850: hour must be between 0 and 23

Default User wrote

You don't use names at Boeing?

> SELECT to_date(date_time_add_ch,'YYYYMMDD:HH24MISS')
> FROM table

> ORA-01850: hour must be between 0 and 23

For the examples you give, it looks fine. So, at least one of the strings in your table is wrong. Simply try:

    SELECT date_time_add_ch
    FROM table
    WHERE substr(date_time_add_ch, 10, 2) not between 0 and 23;

Arjan.
Just another default user. Received on Wed May 19 1999 - 17:00:25 CDT