Home » RDBMS Server » Server Utilities » problem loading date format field using sql*loader
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
Previous Topic: How to use to_char function in sql * laoder control file
Next Topic: Re: Introduce myself to thegreat DBA world
Goto Forum:
  


Current Time: Mon May 23 21:45:36 CDT 2022