Home » U++ Library support » U++ SQL » Timestamp accuracy in postgres and upp
Timestamp accuracy in postgres and upp [message #33055] |
Tue, 05 July 2011 15:44 |
Zbych
Messages: 325 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)
|
|
|
Goto Forum:
Current Time: Mon Apr 29 18:02:37 CEST 2024
Total time taken to generate the page: 0.03175 seconds
|