Re: Interesting datetime problem
Hi. I meant the system environment variable. I do not really believe that it causes the problem, because it shouldn't be able to shift by a whole day. But this is the only thing I know of which may influence time values. On second thought, I really think it isn't TZ, because that influences only the value of NOW(), but not of constant values. So please post an example (i.e. INSERT and SELECT), which shows the problem you describe and a DESCRIBE for the table in question. Bye, Benjamin. On Tue, May 28, 2002 at 06:20:04PM -0400, [EMAIL PROTECTED] wrote: You could be correct about the time zone problem in this sql. I'm somewhat of a MySQL newbie -- do you mean the system environment variable or is there a MySQL environment variable for TZ? [...] Maybe your TZ (timezone) environment variable is set to a strange value? If not, could you provide a full example, so that we can try to reproduce it and see whether this is a local behaviour of your machine or a common MySQL behaviour. [...] I have an interesting problem when updating columns of type DATETIME. It seems that exactly one day is subtracted from the DATETIME value that I submit in an update query. Has anyone encountered this? Any ideas? -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Interesting datetime problem
Hi. Maybe your TZ (timezone) environment variable is set to a strange value? If not, could you provide a full example, so that we can try to reproduce it and see whether this is a local behaviour of your machine or a common MySQL behaviour. Bye, Benjamin. On Tue, May 28, 2002 at 01:27:18PM -0400, [EMAIL PROTECTED] wrote: Hi, I have an interesting problem when updating columns of type DATETIME. It seems that exactly one day is subtracted from the DATETIME value that I submit in an update query. Has anyone encountered this? Any ideas? Kevin -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Interesting datetime problem
You could be correct about the time zone problem in this sql. I'm somewhat of a MySQL newbie -- do you mean the system environment variable or is there a MySQL environment variable for TZ? Thanks, Kevin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Benjamin Pflugmann Sent: Tuesday, May 28, 2002 6:19 PM To: Kevin Carlson Cc: Mysql Subject: Re: Interesting datetime problem Hi. Maybe your TZ (timezone) environment variable is set to a strange value? If not, could you provide a full example, so that we can try to reproduce it and see whether this is a local behaviour of your machine or a common MySQL behaviour. Bye, Benjamin. On Tue, May 28, 2002 at 01:27:18PM -0400, [EMAIL PROTECTED] wrote: Hi, I have an interesting problem when updating columns of type DATETIME. It seems that exactly one day is subtracted from the DATETIME value that I submit in an update query. Has anyone encountered this? Any ideas? Kevin -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php