On 7 Aug 2003 at 15:27, Andy Jackman wrote: > 1) I was investigating the unix_timestamp routine in mysql (version > 3.23.46-nt) and for some reason the unix epoch (1-1-1970) was returned > with a value of -3600.
That's what I'd expect if the time zone was set to -0100, since MySQL assumes the string represents a date-time in the server time zone. Is your server set to GMT, or is there some summertime adjustment occurring? > 2) The function > from_unixtime(n) wraps on my server after 2^31 seconds. e.g. select > from_unixtime(2147483648) returns "1900-01-00 00:00:00". Odd, on mine it gives "1901-12-13 15:45:52", which is the same as FROM_UNIXTIME(-2147483648), which is what I would expect if the argument to FROM_UNIXTIME() is a signed integer. -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
