Re: Loading to date datatype & Year 2000

andrea_johnson_at_wolfe.net wrote:
>
> I'm new to Oracle (my disclaimer). [Workgroup Server 7.3 Solaris 2.5]
>
> I've been testing SQL*Loader with loading my flat/tab-delimited
> current-database data into my new Oracle tables. I had to convert my
> yyyymmdd format data into Oracle's dd-mon-yy DATE datatype format for
> Oracle to accept it into the DATE datatype specified new columns.
>
> My questions are: _Must_ I convert to that format (the data is heavy on
> dates and will require lots of application-driven arithmetic)--will julian
> dates (if not my above current format) not be recognized and
> auto-converted to DATE?
>
> and
>
> The dd-mon-yy format seems suspiciously non-year-2000 compliant...Must/can
> I change a default DATE setting -- or can somebody clue me in Oracle and
> the next century issue.
>
> (thanks)
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet

SQL*Loader allows you to specify the format of your input date in quotes "YYYYMMDD" .

-- 
John P. Higgins      Voice:    (309)765-7868
Deere & Company      Fax:      (309)765-7800
John Deere Road      Internet: jh33378nospam_at_deere.com
Moline, IL 61265     Opinions: My Own