Re: UNIX_TIMESTAMP Duplicate key
From what I understand as I googled the subject and some people say it's because the server's timezone.
The disadvantage if UNIX_TIMESTAMP is that they are not insert as a vulgar Date in a table. They are rather convert based on server timezone.
What to perhaps make sense, since with my C# generator, duplicates occur in the end of March and it is at this date in quebec that we change the date (Day Saving Time). So, in this day, there may be 12 times the same 5 minutes since the time is back 1 hour !
This table is used to store values acquisition controller and therefore our acquisition system do not care the DST. We always inserting the same time for a day, 00:00:00 to 23:55:55.
So, is it possible in MySQL to insert values UNIX_TIMESTAMP regardless of DST ? And also retrieve (FROM_UNIXTIME) the same date that we inserted (UNIX_TIMESTAMP).
Subject
Written By
Posted
Re: UNIX_TIMESTAMP Duplicate key
January 09, 2010 10:23AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.