| Behaviour of Timestamp DataType [message #228256] |
Mon, 02 April 2007 05:02  |
saurabhsoni
Messages: 3
Registered: April 2007
Location: Indonesia
|
Junior Member |
|
|
Hi
I am using a db which is being updated on realtime basis. In my db I am using timetamp as datatype for few of the fields.Now I had observed that whenever a record comes which has a value fro that column greater than the current time then it takes long time to insert that record in to db.There is no constraint defined on that field.So my question is : Is there any limitation on timestamp datatype that it can't accept a value greater than the current time?
Thanks in advance....
Saurabh
|
|
|
|
|
|
|
|
|
|
| Re: Behaviour of Timestamp DataType [message #228531 is a reply to message #228429] |
Tue, 03 April 2007 05:20  |
orausern
Messages: 826
Registered: December 2005
|
Senior Member |
|
|
| Quote: |
it is partcularly for those records only for which I am getting the values in future date(may be 6 or 7 hrs ahead of current time) or sometimes for next date also.
|
so with this info, you create a test case and prove or disprove. I mean , try to manually insert such a record in the db(i mean a record having similar characteristic) and check for yourself and post the findings.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
