Home » RDBMS Server » Server Utilities » Getting date from header of csv and load it to a table
Getting date from header of csv and load it to a table [message #292135] Tue, 08 January 2008 00:01 Go to next message
vanathi
Messages: 74
Registered: December 2007
Location: India
Member
Hi,

Asset Summary,01042008 09:17:08,23975

this is the header of the csv file.
I have to get the date and put it in a table in the mm/dd/yyyy format.(the format in the table is mmddyyyy).using sqlloader.
In control file, how can I get it?


Please advice.

[Updated on: Tue, 08 January 2008 00:02]

Report message to a moderator

Re: Getting date from header of csv and load it to a table [message #292144 is a reply to message #292135] Tue, 08 January 2008 00:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

I have to get the date and put it in a table in the mm/dd/yyyy format

Date datatype doesn't have a format, you choose the format when you query the value.

Regards
Michel
Re: Getting date from header of csv and load it to a table [message #292146 is a reply to message #292144] Tue, 08 January 2008 00:53 Go to previous messageGo to next message
vanathi
Messages: 74
Registered: December 2007
Location: India
Member
Ok..Can I have the date atleast?
Re: Getting date from header of csv and load it to a table [message #292151 is a reply to message #292135] Tue, 08 January 2008 01:22 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>..Can I have the date atleast?
Sure, why not.
Re: Getting date from header of csv and load it to a table [message #292153 is a reply to message #292146] Tue, 08 January 2008 01:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes:
Database Utilities
Part II SQL*Loader
Chapter 9 Field List Reference
Section SQL*Loader Datatypes
Subsection Datetime and Interval Datatypes

Regards
Michel
Re: Getting date from header of csv and load it to a table [message #292224 is a reply to message #292151] Tue, 08 January 2008 04:09 Go to previous messageGo to next message
vanathi
Messages: 74
Registered: December 2007
Location: India
Member
How can I read that date from the header?
I am new to use the control files.


Please advice.
Re: Getting date from header of csv and load it to a table [message #292225 is a reply to message #292224] Tue, 08 January 2008 04:14 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
And you'll remain "new" unless you start creating control files on your own. Do the initial effort, write you own version and - if it doesn't work, come back.
Re: Getting date from header of csv and load it to a table [message #292227 is a reply to message #292225] Tue, 08 January 2008 04:17 Go to previous messageGo to next message
vanathi
Messages: 74
Registered: December 2007
Location: India
Member
I am continuing my teammate's work.
The control files are already there. I have to modify it.
Re: Getting date from header of csv and load it to a table [message #292235 is a reply to message #292227] Tue, 08 January 2008 04:33 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So post it but before read the link I posted and explain why you can't do it with this link.

Regards
Michel
Previous Topic: oracle export
Next Topic: Import & Export Partition tables
Goto Forum:
  


Current Time: Sun Dec 04 06:36:16 CST 2016

Total time taken to generate the page: 0.10711 seconds