U++ framework: U++ SQL » Timestamp accuracy in postgres and upp

Home » U++ Library support » U++ SQL » Timestamp accuracy in postgres and upp

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

Re: Timestamp accuracy in postgres and upp [message #33299 is a reply to message #33092]

Sat, 23 July 2011 09:15

mirek
Messages: 14291
Registered: November 2005

Ultimate Member

Zbych wrote on Wed, 06 July 2011 09:02

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.

What I am not getting is why it finds the log the first time, actually...

I mean, if the select is something like

Select().From(LOG).Where(timestamp >= 16:00 && timestamp < 17:00)

(and than move forward).

In fact, I am posting this because I have very similar arrangemnt in one of mine apps, so I would like to know if I am missing something Smile

Report message to a moderator

[Message index]

		Timestamp accuracy in postgres and upp By: Zbych on Tue, 05 July 2011 15:44
		Re: Timestamp accuracy in postgres and upp By: mirek on Wed, 06 July 2011 14:30
		Re: Timestamp accuracy in postgres and upp By: Zbych on Wed, 06 July 2011 15:02
		Re: Timestamp accuracy in postgres and upp By: zsolt on Thu, 07 July 2011 13:17
		Re: Timestamp accuracy in postgres and upp By: mirek on Sat, 23 July 2011 09:15
		Re: Timestamp accuracy in postgres and upp By: Zbych on Sat, 23 July 2011 18:14
		Re: Timestamp accuracy in postgres and upp By: mirek on Sat, 30 July 2011 18:59

Previous Topic:	SqlArray and data validation
Next Topic:	[SQLITE] New version (3.7.0) introduces write-ahead logging.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun May 24 19:57:29 GMT+2 2026

Total time taken to generate the page: 0.00658 seconds