Re: UNIX_TIMESTAMP - Can anyone explain this behavior?

2009-04-21 Thread Martijn Engler
Hi Keith, I'm not sure, but this might be DST that's in your way. Have you looked into that? Have a nice day, - Martijn On Mon, Apr 20, 2009 at 18:34, Keith Hughitt keith.hugh...@gmail.com wrote: Hi all, Does anyone know what is going on here: //Query: select

UNIX_TIMESTAMP - Can anyone explain this behavior?

2009-04-20 Thread Keith Hughitt
Hi all, Does anyone know what is going on here: //Query: select UNIX_TIMESTAMP(TIMESTAMP('2003-01-01 00:00:00')) as first, UNIX_TIMESTAMP(TIMESTAMP('2003-10-05 00:00:00')) as second, UNIX_TIMESTAMP(TIMESTAMP('2004-01-01 00:00:00')) as third; ++++ | first