On 31/03/2015 12:20, Larry Martell wrote:
On Tue, Mar 31, 2015 at 1:13 AM, Andrew Moore wrote:
When you use a timezone with DST there is no such thing as 2.30am on the
date of changeover. That hour doesn't exist.
I am using UCT - I am not using a timezone.
In MySQL 5 and above, TIMESTAMP va
On Tue, Mar 31, 2015 at 1:13 AM, Andrew Moore wrote:
> When you use a timezone with DST there is no such thing as 2.30am on the
> date of changeover. That hour doesn't exist.
I am using UCT - I am not using a timezone.
> Look up the difference between timestamp and datetime data types.
I did do
When you use a timezone with DST there is no such thing as 2.30am on the
date of changeover. That hour doesn't exist.
Look up the difference between timestamp and datetime data types.
A
On 31 Mar 2015 05:43, "Larry Martell" wrote:
> I have a column that was a timestamp type. I was inserting row
I have a column that was a timestamp type. I was inserting rows using
NOW(). When we switched to DST and the hour from 2am to 3am was
non-existent I of course had no data for that hour. For reasons I
don't need to go into, that missing hour caused problems downstream.
To prevent this from happening
