Re: strange proble with to_date function in select query
- From: Jared Still <jkstill@xxxxxxxxx>
- To: bpawlows@xxxxxxxxx
- Date: Fri, 24 Jul 2009 10:26:11 -0700
On Fri, Jul 24, 2009 at 5:45 AM, Bartek <bpawlows@xxxxxxxxx> wrote:
>
> and submitdatetime >= to_date('20090713135318', 'yyyymmddhh24miss') --
> THIS CONDITION ADDED
> order by sequencenumber
>
> gives ORA-01841 error:
>
> select tid, sequencenumber, to_date(submitdate||submittime,
> 'yyyymmddhh24miss') submitdatetime
> *
> ERROR at line 2:
> ORA-01841: (full) year must be between -4713 and +9999, and not be 0
>
>
> AND this query:
> ...
>
> Could somebody give me any hint how can I solve this problem?
>
Yes, including a sample of the failing results would be most helpful.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
