Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: each & every day

Re: each & every day

From: Jim Kennedy <kennedy-down_with_spammers_at_attbi.com>
Date: Wed, 25 Dec 2002 20:07:36 GMT
Message-ID: <ceoO9.504032$QZ.74981@sccrnsc02>


Amen, right on.
Jim
"Paul Brewer" <paul_at_paul.brewers.org.uk> wrote in message news:3e0a0f57$1_3_at_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:07:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US