Home » SQL & PL/SQL » SQL & PL/SQL » How to insert milliseconds in date field?
icon6.gif  How to insert milliseconds in date field? [message #214763] Thu, 18 January 2007 00:18 Go to next message
fortunethiyagu
Messages: 94
Registered: December 2006
Member

Is it possible to insert milliseconds in date field.

Table structure
create table temp(ad date);


ad is the column name which needs following format to be inserted.

'DD-MON-YYYY HH:MI:SS:FF3'


I tried the following code which throws error message like 'date format not recognized'.

insert into temp values(to_date(sysdate,'DD-MON-YYYY HH:MI:SS:FF3'));


AD is date field not a timestamp. How to solve this problem?

-thiyagarajan

[Updated on: Thu, 18 January 2007 00:21]

Report message to a moderator

Re: How to insert milliseconds in date field? [message #214770 is a reply to message #214763] Thu, 18 January 2007 00:41 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
No. DATE is accurate only to the second. You need TIMESTAMP.

Ross Leishman
icon14.gif  Re: How to insert milliseconds in date field? [message #214799 is a reply to message #214770] Thu, 18 January 2007 02:22 Go to previous message
fortunethiyagu
Messages: 94
Registered: December 2006
Member

Cool thanks rleishman..

Got the point...will try with that...
Previous Topic: SQL Query
Next Topic: EXISTS in the IF statement
Goto Forum:
  


Current Time: Wed Dec 07 20:42:45 CST 2016

Total time taken to generate the page: 0.43893 seconds