Re: strange proble with to_date function in select query
Date: Fri, 24 Jul 2009 10:26:11 -0700
On Fri, Jul 24, 2009 at 5:45 AM, Bartek <bpawlows_at_gmail.com> 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.
Certifiable Oracle DBA and Part Time Perl Evangelist