Re: each & every day

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Wed, 25 Dec 2002 20:03:34 -0000
Message-ID: <3e0a0f57$1_3@mk-nntp-1.news.uk.worldonline.com>

"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