Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: each & every day
"Nikolas Perdikis" <nper_at_ath.forthnet.gr> wrote in message
news:1040816146.811399_at_athprx02...
> Each day i discover a new ORA-xxxxx i dont consider waisted.
> Today i discovered ORA-14120 (for not including the century in my
date-field
> range partition clauses.
>
>
Nikolas,
This is a general rant, not one specifically aimed at you.
Anybody remotely involved with or affected by the Y2K issue would know that one routinely specifies 4 digit years.
Anyone remotely involved with or affected by the Windoze date format issue would know that one routinely uses the TO_DATE function when submitting SQL to an Oracle database, so that (for example) the months don't get mixed up with the days.
Regards,
Paul
Received on Wed Dec 25 2002 - 14:03:34 CST