The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
0answers
262 views

Logic to convert a UTC date-time to a specific time zone

I have a table which has 1 row per event. Each event has a datetime stamp column which has values in UTC time. Each row has an associated local timezone in which the event occurred. I have a DIM ...
0
votes
0answers
8 views

Fine grained (milliseconds) temporal indexes in neo4j

What are the best practices for modeling fine grained timelines in neo4j? If I were to use milliseconds as the grain in the pattern described here and here would it prove somehow problematic and ...
0
votes
0answers
36 views

is HyperTable timestamp sensitive to Y2038?

I've been investigating HyperTable to find out more about it's TimeStamp field, i'm still wondering at which future date will the timestamp field wrap around?
0
votes
0answers
67 views

database timestamp

What's the definition of timestamp? The timestamp is just for a transaction? ( no matter what actions in the transaction. The timestamp is always the time when the transaction happened.) OR the ...
0
votes
0answers
113 views

setting timestamp column as pk to prevent concurrent editing of records?

While I was familiarizing myself with all the new data types in MySQL, I noticed the TIMESTAMP data type, and thought "What if I make this TIMESTAMP field and the CustomerID field (the other pk) a ...
-1
votes
0answers
26 views

How to correct my Oracle SYSTIMESTAMP?

My database's timestamp has 8 second difference with my OS system time (as well as time from the internet). This caused some bug in my code. How to correct this?