MySQL Forums
Forum List  »  Newbie

Re: UNIX_TIMESTAMP Duplicate key
Posted by: Martin Beaudet
Date: January 09, 2010 10:23AM

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).

Options: ReplyQuote


Subject
Written By
Posted
January 08, 2010 07:48PM
Re: UNIX_TIMESTAMP Duplicate key
January 09, 2010 10:23AM
January 10, 2010 03:57PM
January 11, 2010 01:31AM
January 11, 2010 11:26PM
January 12, 2010 11:37PM
January 13, 2010 09:32AM
January 13, 2010 09:08PM


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.