default behaviour of timestamp [message #269967] |
Tue, 25 September 2007 04:49  |
karismapanda
Messages: 58 Registered: January 2007
|
Member |
|
|
Hi,
I have a table with a column of timestamp data type.
SQL> desc test
Name Null? Type
----------------------------------------- -------- ----------------------------
C_TIME TIMESTAMP(3)
when i am inserting a record its rounding off the fractional second part.
like........
SQL> insert into test values('2007/09/25 03:03:36:14568 PM');
1 row created.
SQL> select * from test;
C_TIME
---------------------------------------------------------------------------
2007/09/25 03:03:36:146000 PM
i need the o/p to be like
2007/09/25 03:03:36:145000 PM
is it the default behaviour or we can do some db level setting so that instead of rounding it will truncate it.
Thanks
|
|
|
Re: default behaviour of timestamp [message #269970 is a reply to message #269967] |
Tue, 25 September 2007 04:56   |
 |
Michel Cadot
Messages: 68737 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
First,
Please read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button.
Please always post your Oracle version (4 decimals).
Then,
You column is defined as TIMESTAMP(3), so timestamp is rounded to the third decimal, this is the correct behaviour.
If you want the data to be truncated then you have to do it yourself.
By the way:
insert into test values('2007/09/25 03:03:36:14568 PM');
Is not a valid statement everywhere and everytime, you have to use TO_TIMESTAMP function.
Regards
Michel
[Updated on: Tue, 25 September 2007 04:57] Report message to a moderator
|
|
|
|