Home » RDBMS Server » Server Utilities » problems with TimeStamp
problems with TimeStamp [message #213871] Fri, 12 January 2007 10:33 Go to next message
Mitr
Messages: 9
Registered: January 2007
Junior Member
I am trying to write a script to upload the data to table from a
.dat file.

I have the follwoing date format in my data file
2006-12-15-11.06.34.736272

in the control file i said
CREAT_DTM "TO_TIMESTAMP(:CREAT_DTM, 'YYYY-MM-DD-HH.MI.SS.MS')"

it throws me an error
ORA-01821: date format not recognized

If I anyone can help me figure out the problem that will be gr8.

Thanks in advance.

Re: problems with TimeStamp [message #213876 is a reply to message #213871] Fri, 12 January 2007 10:40 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
From where did you get this 'MS'?
You should use the following
select TO_TIMESTAMP('2006-12-15-11.06.34.736272', 'YYYY-MM-DD-HH.MI.SS.FF6') from dual;
By
Vamsi
Re: problems with TimeStamp [message #213880 is a reply to message #213876] Fri, 12 January 2007 11:09 Go to previous message
Mitr
Messages: 9
Registered: January 2007
Junior Member
Oops ..My bad...

Thank q Vamsi.
Previous Topic: query regarding sqlldr
Next Topic: SQL Loader question: How to use two WHEN clauses for a single table load
Goto Forum:
  


Current Time: Sat Dec 07 05:05:16 CST 2024