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