Re: Using date format in Oracle??

From: Dan Meehan <dmeehan_at_csun.edu>
Date: 1997/06/19
Message-ID: <dmeehan.451.000A8B48@csun.edu>#1/1

In article <33a3fafb.75679495_at_news.ececs.uc.edu> teetshd_at_ucbeh.san.uc.edu (greg teets) writes:
>From: teetshd_at_ucbeh.san.uc.edu (greg teets)
>Subject: Re: Using date format in Oracle??
>Date: Mon, 16 Jun 1997 22:57:53 GMT

>Thanks, Graham

>Sorry for the lack of detail. I'm trying to load a table through
>SQLLoader from a text file. I read the manual and got kind of
>confused.

To use a date in SQLLoad, do something like:

UPDATE_DATE POSITION (45:52) DATE "YYYYMMDD", The format following the DATE keyword can be any valid Oracle date format. If you do not use the DATE clause, Loader will assume the default date format (DD-MON-YY). Enjoy!

Dan Meehan Received on Thu Jun 19 1997 - 00:00:00 CDT