Thanks, That was it we had some hours over 24. I thought it was syntax.
Arjan van Bentem wrote:
>
> 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 Thu May 27 1999 - 09:02:58 CDT
