Home » U++ Library support » U++ SQL » Timestamp accuracy in postgres and upp
| Re: Timestamp accuracy in postgres and upp [message #33092 is a reply to message #33090] |
Wed, 06 July 2011 15:02   |
Zbych
Messages: 326
Registered: July 2009
|
Senior Member |
|
|
I don't want to change TIME definition because of backward compatibility, but it is your decision.
In my application I keep some logs in a database. Once in a while another application transfers those logs from the database to main server and I use timestamp to remember which logs were already transfered.
If the last log has timestamp 17:00:00.5 (timestamp is added automatically by postgres), upp rounds it to 17:00:00. Next time I will search for logs with timestamp >17:00:00 and the log with timestamp 17:00:00.5 will be transfered again. That is why I need the same timestamp resolution in both upp and database.
[Updated on: Wed, 06 July 2011 15:04] Report message to a moderator |
|
|
|
Current Time: Thu May 16 09:59:24 CEST 2024
Total time taken to generate the page: 0.02443 seconds
|
Members
Pages
Help
Register
Login
Home
