Re: strange proble with to_date function in select query
From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 24 Jul 2009 10:26:11 -0700
Message-ID: <bf46380907241026p558d18dei54a5d530416a6141_at_mail.gmail.com>
On Fri, Jul 24, 2009 at 5:45 AM, Bartek <bpawlows_at_gmail.com> wrote:
Date: Fri, 24 Jul 2009 10:26:11 -0700
Message-ID: <bf46380907241026p558d18dei54a5d530416a6141_at_mail.gmail.com>
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.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jul 24 2009 - 12:26:11 CDT