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