OraFAQ Forum: Server Utilities » problems with TimeStamp

Home » RDBMS Server » Server Utilities » problems with TimeStamp

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

problems with TimeStamp [message #213871]

Fri, 12 January 2007 10:33

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.

Report message to a moderator

Re: problems with TimeStamp [message #213876 is a reply to message #213871]

Fri, 12 January 2007 10:40

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

Report message to a moderator

Re: problems with TimeStamp [message #213880 is a reply to message #213876]

Fri, 12 January 2007 11:09

Mitr
Messages: 9
Registered: January 2007

Junior Member

Oops ..My bad...

Thank q Vamsi.

Report message to a moderator

Previous Topic:	query regarding sqlldr
Next Topic:	SQL Loader question: How to use two WHEN clauses for a single table load

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 21:43:59 CST 2024