Re: Formating SYSDATE in SQL Loader

From: TurkBear <john.greco_at_dot.state.mn.us>
Date: Thu, 06 Mar 2003 09:57:55 -0600
Message-ID: <7sre6vslgl30q7pgs3fbccrurabdtmaete@4ax.com>

Just a thought, but why do you care?

All DATE type fields in Oracle are date/time ( in 9i both date and timestamp as well) so just format the output to 'hide' the time component instead of trying to manipulate the input...

rick_markham_at_earthlink.net (Rick) wrote:

>When I use SYSDATE in a SQL Loader scripts as a default date, it loads
>a data/time in the table.
>
>ie PERIOD_EFFECTIVE_DATE SYSDATE
>
>I would like just the date as you would get using trunc(sysdate) in
>sql. How is that done?
>
>Thanks
Received on Thu Mar 06 2003 - 09:57:55 CST