tags:

views:

62

answers:

1
Q: 

Mysql timestamp timezone wierdness

So I want to grab records from a table based on the day of the month the record was created. This information is stored in a unix timestamp. During testing I created new test records and through in some timestamps for specific day and times that I had converted to timestamps using an online converter. I used...

01/29/2010-02:00:00

Right now I'm using...

FROM_UNIXTIME(timestamp, '%d') == 29

This should work for all times on the 29th day of every month. But it is calculating the timestamp to be 5 hours behind the actual value of the timestamp. So when I just run a FROM_UNIXTIME on the timestamp it returns 01/28/2010-21:00:00. I was hoping someone could give an explanation for this, if there is an easy fix or should I just code the program to expect the timezone to be a factor.

A: 

The FROM_UNIXTIME function automatically converts the datetime to the current timezone.

Aglystas  2010-03-10 16:59:27

related questions

Handling and storing elapsed time
How do I convert local time to UTC in Python?
Mono's DateTime Serialization
Best practices for DateTime serialization in .Net framework 3.5/SQL Server 2008
Parsing exact dates in C# shouldn't force you to create an IFormatProvider
C# Casting vs. Parse
.NET Date Const (with Globalization)
Dynamic regex for date time formats
What is the simplest way to find the difference between 2 times in python?
Best way to convert DateTime to "n Hours Ago" in SQL
What's a good way to overwrite DateTime.Now during testing?
Datetime arithmetic with a string in Ruby
How can I get the DateTime for the Start of the Week?
Is DateTime.Now the best way to measure a function's performance?
SQL Server DateTime conversion failure
Natural language date/time parser for .NET?
What's a good way to check if two datetimes are on the same calendar day in TSQL?
Why does this python date/time conversion seem wrong?
Dealing with PHP server and MySQL server in different time zones
How do I parse and convert DateTime's to the RFC 3339 date-time format?
HOWTO - Compare a date string to datetime in SQL Server?
Best method for varchar date validation in Sybase (T-SQL)?
What's the BEST way to remove the time portion of a datetime value (SQL Server)
How do I calculate relative time?
How do I calculate someone's age in C#?