Re: questions about timestamps and DST

2015-03-31 Thread Mark Goodge
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

Re: questions about timestamps and DST

2015-03-31 Thread Larry Martell
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

Re: questions about timestamps and DST

2015-03-30 Thread Andrew Moore
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