OraFAQ Forum: Server Utilities » problem loading date format field using sql*loader

Home » RDBMS Server » Server Utilities » problem loading date format field using sql*loader

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

problem loading date format field using sql*loader [message #365800]

Fri, 04 February 2000 16:24

karunakar pabba
Messages: 5
Registered: February 2000

Junior Member

Hi
I have date format in my data file like 'mmddyy'and if i transfer data using sql* loader its loading but the year is loading as 2000 instead of 19xx,and also i need to use trailing nullcols in my control file as there is no data for some of columns.
Should i use to_char or to_date function in my control file please send me the syntaxes with examples.
My data file is having ',' as field separator and also enclosed in '"' for character data type field.

Thanks in advance

-- karun

Report message to a moderator

Previous Topic:	How to use to_char function in sql * laoder control file
Next Topic:	Re: Introduce myself to thegreat DBA world

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 07:36:26 CDT 2024