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

Timestamp accuracy in postgres and upp [message #33055]

Tue, 05 July 2011 15:44

Zbych
Messages: 332
Registered: July 2009

Senior Member

Hi,

Definition of TIME in database schematic doesn't specify accuracy and (at least) postgres keeps time in micro seconds. Since upp time accuracy is 1s, it sometimes leads to some problems. Maybe there should be another definition of TIME that has the same accuracy like upp? What do you think?

My proposition is to add following definitions to PostgreSQLSchema.h:

#define TIME_SEC(x) COLUMN("timestamp(0)", Time, x, 0, 0)
#define TIME_SEC_(x) COLUMN_("timestamp(0)", Time, x, 0, 0)

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 18:30:39 GMT+2 2026

Total time taken to generate the page: 0.00853 seconds