From: John Daisley [mailto:daisleyj...@googlemail.com]
Sent: Friday, June 03, 2011 6:09 AM
To: Rocio Gomez Escribano
Cc: mysql@lists.mysql.com
Subject: Re: timezone
now() returns the current system time which doesn't really have a great deal to
do with time zones.
[JS] I think
.
>
>
> --
>
> *From: *"John Daisley"
> *To: *"Rocio Gomez Escribano"
> *Cc: *mysql@lists.mysql.com
> *Sent: *Friday, 3 June, 2011 12:08:34 PM
> *Subject: *Re: timezone
>
>
> now() returns the current system time whi
xplicitly, so I don't
think so.
- Original Message -
> From: "John Daisley"
> To: "Rocio Gomez Escribano"
> Cc: mysql@lists.mysql.com
> Sent: Friday, 3 June, 2011 12:08:34 PM
> Subject: Re: timezone
> now() returns the current system tim
; *Rocío Gómez Escribano*
>
> r.go...@ingenia-soluciones.com
>
>
>
> [image: Descripción: cid:image002.jpg@01CB8CB6.ADEBA830]
>
> Polígono Campollano C/F, nº21T
>
> 02007 Albacete (España)
>
> Tlf:967-504-513 Fax: 967-504-513
>
> www.ingenia-soluciones.com
&
Rocio Gomez Escribano
CC: mysql@lists.mysql.com
Asunto: Re: timezone
Have you populated the timezone tables? Run this query if you are not sure.
SELECT COUNT(*) FROM mysql.time_zone_name;
If it returns 0 then you need to populate the them as per the instructions
here http://dev.mysql.co
Have you populated the timezone tables? Run this query if you are not sure.
*SELECT COUNT(*) FROM mysql.time_zone_name;*
*
*
***If it returns 0 then you need to populate the them as per the
instructions here
http://dev.mysql.com/doc/refman/5.5/en/time-zone-support.html*
Default timezone in mysql
> -Original Message-
> From: Elim PDT [mailto:e...@pdtnetworks.net]
> Sent: Monday, March 29, 2010 5:57 PM
> To: mysql@lists.mysql.com
> Subject: timezone questions
>
> data from one server in timezone A ported to another server
> in timezone B, what will happen for the records with date
Hello.
See:
http://dev.mysql.com/doc/refman/5.0/en/time-zone-support.html
[EMAIL PROTECTED] wrote:
> Dear Friends,
> I need to do the timezone settings so that now() gives the system
> time.Actually first i have installed mysql on a different timezone han
> changed the system time zone but per
I use this in my.cnf (along with mysqld_multi settings fwiw) and it works
great (mysql version 4.0.X):
[mysqld_safe]
timezone = GMT
It depends on how you start up mysqld.. If you don't use mysqld_safe, the
above wont work for you.
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
> I've tried putting TZ = GMT and TZ = UTC into the my.cnf file but then
> mysql won't even start.
These should be set as environment variables, not as configuration
options. You could also try setting time_zone system variable with
set @@time_zone=GMT.
Petr
--
MySQL General Mailing List
For l
> -Original Message-
> From: Jeff [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 21, 2005 08:55
> To: mysql@lists.mysql.com
> Subject: Timezone setting wrong?
>
>
> I've got a RHEL3 server I just installed with mysql 4.0.16.
>
> The hardware clock and system clock are both set t
In the last episode (Sep 10), Terence said:
> Does MySQL have something similiar to
>
> SELECT TIMESTAMP '2001-02-16 20:38:40' AT TIME ZONE 'Canada/Pacific';
>
> I need to handle the timestamp in the database. Previous posts and some
> googling suggests it should be in the PHP layer which is not
Joseph Cochran wrote:
Some countries have multiple timezones, so it is not sufficient to
know the country code in order to get the timezone. If they have
previously posted the timezone, however, then it should be possible to
store that information in a cookie on the client machine that your web
l
Some countries have multiple timezones, so it is not sufficient to
know the country code in order to get the timezone. If they have
previously posted the timezone, however, then it should be possible to
store that information in a cookie on the client machine that your web
layer can retrieve. If yo
> Yes. MySQL attempts to get the current time zone from the OS, but this can
> be overridden by setting the TZ variable. (The manual suggests doing this
in
> the safe_mysqld script; there's already code in there for setting it from
a
> command line argument.)
>
> Valid settings of TZ are techni
Kevin,
Monday, June 10, 2002, 5:20:00 PM, you wrote:
K> I am using the now() function to insert the current timestamp in a mysql
K> table.
K> My problem is that the server is using EST while I would like the time to
K> reflect PST.
K> Can this be done?
K> Thanks.
It depends on what OS do you us
Yes. MySQL attempts to get the current time zone from the OS, but this can
be overridden by setting the TZ variable. (The manual suggests doing this in
the safe_mysqld script; there's already code in there for setting it from a
command line argument.)
Valid settings of TZ are technically not "tim
> >Start the server with the desired TZ set.
>
> That's all fine and good, but difficult switch back and forth every 10
> minutes while that query runs for local data, then for the remote data.
=Agreed you must stick with either one or the other, right?
=Wrong! To fix the problem of different of
Jeremy Wilson wrote:
> At 01:07 PM 11/13/01 -0600, Gerald Clark wrote:
> >Start the server with the desired TZ set.
>
> That's all fine and good, but difficult switch back and forth every 10
> minutes while that query runs for local data, then for the remote data.
The way I deal with it (and I d
At 01:07 PM 11/13/01 -0600, Gerald Clark wrote:
>Start the server with the desired TZ set.
That's all fine and good, but difficult switch back and forth every 10
minutes while that query runs for local data, then for the remote data.
-
Start the server with the desired TZ set.
Jeremy Wilson wrote:
> I have a data collection script which rolls raw data into a formatted
> table, based on year/month/day. I've been requested to roll up this raw
> data based on a different timezone - 3 hours behind - to better coincide
> with rep
> > The small problem in mysql is it does not check if parameter is
> > correct in configure script - this produced the problem...
> > Peter mailto:[EMAIL PROTECTED]
Yes, I don't know of any clear way of handling this with
autoconf. Basically, if your option starts wi
Ok :)
the problem solved. It was a wrong glibc after all.
Regards,
Heikki
At 01:07 PM 8/8/01 +0400, you wrote:
>Hello Heikki,
>
> Sorry for confuse. The problem is The first complied binary I've
> checked which was fine was complied with --with-other-glibc=XXX
> therefore the correct option
Peter Zaitsev writes:
> Hello Michael,
>
> Tuesday, August 07, 2001, 10:20:18 PM, you wrote:
>
> The question is which place do you do aply timezone ?
>
> I found the following interesting thing: Then mysql is started it uses
> correct timestamp, therefore INNODB is started with wrong timestamp
On Tuesday 07 August 2001 09:10, Heikki Tuuri wrote:
> Hi!
>
> No idea what is wrong. Below is the code which
> prints the timestamp in InnoDB:
> .
>
> struct tm cal_tm;
> struct tm* cal_tm_ptr;
> time_t tm;
>
> time(&tm);
>
> #ifdef HAVE_LOCALTIME_R
> localtime_
TED]>; [EMAIL PROTECTED]
<[EMAIL PROTECTED]>; [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Tuesday, August 07, 2001 5:41 PM
Subject: Re: Timezone problem.
>Hello Michael,
>
>Tuesday, August 07, 2001, 10:20:18 PM, you wrote:
>
>OK guys I think I've found the problem
Hello Michael,
Tuesday, August 07, 2001, 10:20:18 PM, you wrote:
OK guys I think I've found the problem.
It seems like new innodb version (40b) does something bad with time.
I've tested 3 binaries
1) Plain .40 with normal GLIBC -> OK
2) Plain .40 with patched GLIBC -> OK
3) Plain .40 with new
Peter Zaitsev writes:
> Hello mysql,
>
> It seems like you made an incomportable changes in 3.23.40 without
> taking a time to write a release note :(
>
> The mysql 3.23.39 used the system timezone by default:
>
> maindb:/spylog/mysql/logs # date
> Tue Aug 7 13:31:56 MSD 2001
>
> | tra
28 matches
Mail list logo
