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
t; have two timezones - it has a single timezone with daylight savings time.
> The real question is, thus, to figure out wether or not you are on DST or
> not.
>
> That, however, I have no idea how to do - the system takes care of it
> automagically. I'm not even sure it gets
I would also like to point out, as an aside, that Spain doesn't actually have
two timezones - it has a single timezone with daylight savings time. The real
question is, thus, to figure out wether or not you are on DST or not.
That, however, I have no idea how to do - the system takes ca
means it takes the
value from the host operating system ( usually set in /etc/timezone ).
You can set the time_zone variable either globally or per session to an
offset of UTC as follows
*SET time_zone='+00:00:00';*
*SET GLOBAL time_zone='+00:00:00';*
Or you can specify
| now() |
+-+
| 2011-06-03 11:28:00 |
+-+
1 row in set (0.00 sec)
Thats correct, in Spain its that time. So, mysql is using the timezone
correctly, isnt it?
Thanks!
Rocío Gómez Escribano
<mailto:r.sanc...@ingenia-soluciones.com> r.g
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
Hello! Im having trouble with timezones.
Im in Spain, we have 2 different timezone now we are in GMT+2, in winter,
this is the GMT+1.
Im looking for an instruction which give me the current timezone, but I
cant find it! Do you know how can I now it?
Thanks!
Rocío Gómez Escribano
set time_zone='Europe/Kiev';
-Original Message-
From: Andre Polykanine [mailto:an...@oire.org]
Sent: Thursday, February 24, 2011 10:23 AM
To: mysql@lists.mysql.com
Subject: Changing the timezone
Hi everyone,
since I'm using the shared hosting, I can't change
Hi everyone,
since I'm using the shared hosting, I can't change the default
timezone for MySql.
Question is: is there any query that I could launch in my connect.php
before other queries to make my timezone change?
For instance, I make a
mysql_query("SET CHARACTER_SET_DATAB
alue from the global
<http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar
_time_zone> time_zone variable, but the client can change its own time zone
with this statement:
mysql> SET time_zone = timezone;
The current session time zone setting affects display and s
I suggest you put your glasses on, then. Getting of that horse might help,
too.
default-time-zone='*timezone*'
>
> If you have the
> SUPER<http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html#priv_super>privilege,
> you can set the global server tim
work in spite of what
the manual says.
On Fri, 2010-10-01 at 15:42 -0700, Daevid Vincent wrote:
> Did you even look at the manual?
>
> http://lmgtfy.com/?q=mysql+set+timezone
>
> First link.
>
>
> > -Original Message-
> > From: Bryan Cantwell [mailto:b
> -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 hap
data from one server in timezone A ported to another server in timezone B,
what will happen for the records with datetime columns?
What is the recommended way of handling this kind of issues? Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Jonas,
your information is somewhat incomplete, but still:
Jonas Silveira wrote:
> Hi,
>
>
>
> I need to change the computer clock (changing the /etc/zoneinfo) but I would
From the file name, I assume it is some Unix platform.
> not restart de MySQL service. The NOW() still returning the o
Hi,
I need to change the computer clock (changing the /etc/zoneinfo) but I would
not restart de MySQL service. The NOW() still returning the old time...
Thanks,
Jonas
Agreed. Store as UTC. You can always convert to the needed timezone during
query or during display. See MySQL's CONVERT_TZ() function.
On Tue, Jul 28, 2009 at 8:29 AM, Brent Baisley wrote:
> MySQL doesn't support timezones (I think Postgres does). I usually
> just store dates a
MySQL doesn't support timezones (I think Postgres does). I usually
just store dates as Greenwich Mean Time and store the time zone hours
offset in a separate field.
Brent Baisley
On Tue, Jul 28, 2009 at 7:59 AM, Manoj Singh wrote:
> Hi All,
>
> Is it possible to store the timezone
Hi All,
Is it possible to store the timezone with datetime data type in mysql or any
other approach available to achieve this in mysql.
Looking for your help.
Thanks,
Manoj
Boyd, Todd M. wrote:
>> My concern is whether the time_zone_id is a fixed reference of the
>> timezone. If the id might (for whatever reason) change in the
>> future, I'd have to store the timezone name.
>
> http://dev.mysql.com/doc/refman/5.1/en/time-zone-support.h
> -Original Message-
> From: Per Jessen [mailto:[EMAIL PROTECTED]
> Sent: Saturday, June 14, 2008 6:23 AM
> To: mysql@lists.mysql.com
> Subject: RE: what is the proper way to store timezone information?
>
> Boyd, Todd M. wrote:
>
> >>
> >> When
n you insert phone numbers into a database--is it
> easier for you to parse back if you do so? If yes, then store the
> formatting. If no/probably not/I don't need to parse it, then just
> store it without.
My concern is whether the time_zone_id is a fixed reference of the
timezo
> -Original Message-
> From: Per Jessen [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 13, 2008 5:17 AM
> To: mysql@lists.mysql.com
> Subject: what is the proper way to store timezone information?
>
> All,
>
> I will be recording timezone information based on
All,
I will be recording timezone information based on user input using the
time zone names from mysql.time_zone_name - names
like 'America/Los_Angeles'.
When recording this information, do I store the full name or just
the 'time_zone_id' which is present in mysql.time_zone_
On Wed, May 14, 2008 at 12:55 PM, Ed W <[EMAIL PROTECTED]> wrote:
> Rob Wultsch wrote:
>>
>> This sounds like expected behavior to me. If you set the timezone one
>> hour forward a timestamp will be one hour forward. The data stored on
>> the server is the same,
Rob Wultsch wrote:
This sounds like expected behavior to me. If you set the timezone one
hour forward a timestamp will be one hour forward. The data stored on
the server is the same, and will display the same if you change the
timezone. The timezone setting when the insert occurred should have
restored the same
> database as before and again replicated the same data across to catch up and
> this time they show the same values. So basically the value retrieved from
> the second database is influenced by the localtime options being different
> on each server *at the time
Rob Wultsch wrote:
On Tue, May 13, 2008 at 2:07 PM, Ed W <[EMAIL PROTECTED]> wrote:
I had naively assumed that dates would always be stored in UTC in the
database and the only effect of localtime would be for display purposes?
Can anyone shed some light on what's happening here please?
On Tue, May 13, 2008 at 2:07 PM, Ed W <[EMAIL PROTECTED]> wrote:
> I had naively assumed that dates would always be stored in UTC in the
> database and the only effect of localtime would be for display purposes?
> Can anyone shed some light on what's happening here please?
"TIMESTAMP values are c
Hi, can anyone explain mysql 5.0.54 handling of replication between two
servers with inconstant /etc/localtime (but the same real clock time for
UTC)
On one server I inserted a new row with "created_at" and "updated_at" as
the same time. Server localtime is GMT+1, created col is a date,
upda
> -Original Message-
> From: Hiep Nguyen [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 06, 2007 12:15 PM
> To: Dirk Bremer
> Cc: David T. Ashley; mysql@lists.mysql.com
> Subject: RE: zipcode to timezone
>
> now, why do they do this??? it doesn't make any se
] www.nisc.coop
-Original Message-
From: Hiep Nguyen [mailto:[EMAIL PROTECTED]
Sent: Friday, July 06, 2007 10:51
To: David T. Ashley
Cc: mysql@lists.mysql.com
Subject: Re: zipcode to timezone
On Fri, 6 Jul 2007, David T. Ashley wrote:
On 7/6/07, Hiep Nguyen <[EMAIL PROTECTED]> wrote:
w
Nguyen [mailto:[EMAIL PROTECTED]
Sent: Friday, July 06, 2007 10:51
To: David T. Ashley
Cc: mysql@lists.mysql.com
Subject: Re: zipcode to timezone
On Fri, 6 Jul 2007, David T. Ashley wrote:
> On 7/6/07, Hiep Nguyen <[EMAIL PROTECTED]> wrote:
>>
>> we have warehouses all
On 7/6/07, John Trammell <[EMAIL PROTECTED]> wrote:
> -Original Message-
> From: Hiep Nguyen [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 06, 2007 10:51 AM
> To: David T. Ashley
> Cc: mysql@lists.mysql.com
> Subject: Re: zipcode to timezone
>
> i don&#x
> -Original Message-
> From: Hiep Nguyen [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 06, 2007 10:51 AM
> To: David T. Ashley
> Cc: mysql@lists.mysql.com
> Subject: Re: zipcode to timezone
>
> i don't think there is any state got 2 timezones, i could be
w.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
> -Original Message-
> From: Hiep Nguyen [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 06, 2007 11:51 AM
> To: David T. Ashley
> Cc: mysql@lists.mysql.com
> Subject: Re: zipcode to timezone
>
> On Fri, 6 Ju
On Fri, 6 Jul 2007, David T. Ashley wrote:
On 7/6/07, Hiep Nguyen <[EMAIL PROTECTED]> wrote:
we have warehouses all over U.S. and i just wonder what is the best way to
find out their timezone base on zipcode. Should i buy a database or is
there any function in mysql or php to get ti
Hiep Nguyen wrote:
Hi there,
we have warehouses all over U.S. and i just wonder what is the best way
to find out their timezone base on zipcode. Should i buy a database or
is there any function in mysql or php to get timezone base on a zipcode?
You may be able to call a web service from
On 7/6/07, Hiep Nguyen <[EMAIL PROTECTED]> wrote:
we have warehouses all over U.S. and i just wonder what is the best way to
find out their timezone base on zipcode. Should i buy a database or is
there any function in mysql or php to get timezone base on a zipcode?
I looked at the z
Hi there,
we have warehouses all over U.S. and i just wonder what is the best way to
find out their timezone base on zipcode. Should i buy a database or is
there any function in mysql or php to get timezone base on a zipcode?
Thanks
T. Hiep
--
MySQL General Mailing List
For list archives
At 11:45 +0300 10/21/06, Ahmad Al-Twaijiry wrote:
Hi everyone
is it possible in Mysql 5.0.1 to set the timezone for a user ?
PS: I don't have root access to mysql, so I'm looking for away to do
it as a normal user.
Time zone support is described here:
http://dev.mysql.com/doc/ref
Hi everyone
is it possible in Mysql 5.0.1 to set the timezone for a user ?
PS: I don't have root access to mysql, so I'm looking for away to do
it as a normal user.
---
Ahmad
http://www.v-tadawul.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
[EMAIL PROTECTED] schrieb:
after changing my system timezone from UTC to MSD i have the following
problem: after restarting mysql server its timezone has not changet at
all:
mysql> show variables like '%zone%';
+--++
| Variable_na
after changing my system timezone from UTC to MSD i have the following
problem: after restarting mysql server its timezone has not changet at
all:
mysql> show variables like '%zone%';
+--++
| Variable_name| Value |
+--++
| system_ti
The starting of the Server with the timezone settings works fine after
setting the TZ variable. I always looked at the output from select
@@global.time_zone. This was SYSTEM and so I beliefed the timezone
wasn't set right on the server.
Thanks and Regards
Michael
Thanks for the help,
Thanks for the help,
but this isn't my problem. When you start the server as shown below, the
SYSTEM Timezone is used for the MySQL server. This could be seen when
executing the query select @@global.time_zone on the server. Than you
must get a SYSTEM in your data. The problem is th
This was done as root and shows that TZ works.
dk:/usr/local/mysql # bin/mysql -V
bin/mysql Ver 14.12 Distrib 5.0.18, for pc-linux-gnu (i686) using
readline 5.0
dk:/usr/local/mysql # echo $TZ
dk:/usr/local/mysql # bin/mysqld_safe --user=mysql &
[1] 802
dk:/usr/local/mysql # Starting mysqld da
Thanks for your help, but this is the problem I have. I can't specify
the timezone right when I start mysql with
mysqld_safe --user=mysql --timezone="America/Argentina/Mendoza"
or by setting the TZ enviroment variable and than start the server.
The timezone setting is ignored eve
or what I although could do to
start my Server in another than the SYSTEM timezone?
I use the MySQL 5.0.18 Server on a Suse Linux 10.0
From:
http://dev.mysql.com/doc/refman/5.0/en/timezone-problems.html
You can set the time zone for the server with the
--timezone=timezone_name option to
Hello everybody,
I have a problem with replication of data from master to slave server.
The problem is, that the master is in a other timezone than the slave
and so inserts with using the now() function creates different values on
master and slave. If I want to update on the master and use
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 t
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 perhaps mysql shows the previous time zone
or the default time zone only.
Pl. tell me how to change that .
I shall
Le jeudi 27 octobre 2005 à 01:12 +0300, Gleb Paharenko a écrit :
> Hello.
>
>
>
> In mysql-5.0.15 it works. Put, say, default_time_zone='+10:00' in
>
> [mysqld] section of your file.
This option works too under MySQL 4.1.11:
[mysqld]
default_time_zone=UTC
mysql> SELECT @@global.time_zone, @@
Hello.
In mysql-5.0.15 it works. Put, say, default_time_zone='+10:00' in
[mysqld] section of your file.
Raphaël 'SurcouF' Bordet wrote:
> Hi,
>
> I want to set up a different timezone that my operating system for MySQL
> upper to 4.1. According to
Hi,
I want to set up a different timezone that my operating system for MySQL
upper to 4.1. According to this article[1], timezone system variable was
changed since 4.1.3. I'm using mysql 4.1.11a from Debian sarge.
I was tried to set system_time_zone into /etc/mysql/my.cnf
unsuccessfully. The
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 Administ
> 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
n the new slave returns
*** 120. row ***
Variable_name: timezone
Value: IST
I'm sure I've missed something simple here but what?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
it should be in the PHP layer which is not an option
> for me.
> My users come from various timezones, and so I plan to store everything
> in GMT (server time) and select the time based on their timezone
> preference which is stored in a user preference table.
Start at http://dev.mysq
.
My users come from various timezones, and so I plan to store everything
in GMT (server time) and select the time based on their timezone
preference which is stored in a user preference table.
Suggestions always welcome :)
Thanks
Terence
--
MySQL General Mailing List
For list archives: http://l
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
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
Hi,
There is a request from mgmt, when user browse the request (web), the
database will return the requested timestamp at their timezone that
previously posted. How do i do that? Do I need store whole country codes
together timezones in database mysql ? Is there any way to find full
country
Dear list,
I never tried any timezone features(options) of mysql and like
to learn from you.
(1) In what situation one need to set mysql timezone?
(I know there are application level timezone solutions)
(2) What the effect if a custome timezone is settled with mysql?
I use mysql for web
Have the location selecting adjust the timezone when it selects. Example
select t + interval 6 hour from t
--
Eric Bergen
[EMAIL PROTECTED]
On Mon, 27 Sep 2004 12:24:36 -0600, Elim Qiu <[EMAIL PROTECTED]> wrote:
> Hi, I'm looking for help on timezone issues.
>
> I
Hi, I'm looking for help on timezone issues.
I'm using mysql for a web application about time related events.
I've two servers in different locations with different timezones.
How to setup the database server so that the datetime value will not
depend on the server machine's
On 12-Apr-2004 Riaan Oberholzer wrote:
> I'm, using mysqldump to dump a complete database on a
> server in The Netherlands and want to load the
> generated SQL onto a server in the USA to make an
> exact copy of the database.
>
> However, I have Timestamp(14) fields that are dumped
> as e.g. "200
I'm, using mysqldump to dump a complete database on a
server in The Netherlands and want to load the
generated SQL onto a server in the USA to make an
exact copy of the database.
However, I have Timestamp(14) fields that are dumped
as e.g. "2004101015" local time and is read as
local time too
At 1:25 +0200 10/14/03, Mikhail Entaltsev wrote:
Hi,
Do you use version 4 or 3?
I am using version 4.0.14.
I thought that I need to use
"set-variable = timezone = CST" for it to work under MySQL 3.
MySQL docs:
"...set-variable = variable=value
This is equivalent to --set-va
Hi,
> Do you use version 4 or 3?
I am using version 4.0.14.
> I thought that I need to use
> "set-variable = timezone = CST" for it to work under MySQL 3.
MySQL docs:
"...set-variable = variable=value
This is equivalent to --set-variable variable=value on the comman
Hi:
Do you use version 4 or 3? I thought that I need to use
"set-variable = timezone = CST" for it to work under MySQL 3.
Also, does anybody know if "CST" is recognized? Or do I have to use GMT-6 or
something like that?
Thanks for your time and help.
King reg
Hi,
I am using these lines in my.cnf at [mysqld_safe] section.
[mysqld_safe]
timezone = GMT
It works fine for me.
Best regards,
Mikhail.
- Original Message -
From: "Juan Antonio Ruiz Zwollo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 13
Hi.
I am trying to change the timezone for MySQL (version 3.23.56) but it does
not seem to work.
Currently the timezone is set to "MDT" (I think its the default for MySQL).
I added the following line to /etc/my.cnf at the [mysqld] section:
set-variable = timezone=CST
But when I t
program.
Does MySQL store TimeZone and DayLight Saving Time changes ?
Or does it have a way to find it once you have a field whose type is
timestamp ?
Thanks a lot in advance for your help,
Patrick, Mariella
-
Before posting
> 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
on what OS do you use. If you use *nix, it's possible. Run
mysqld with --timezone option. If you use Windows you can only set up
environment variable.
K> --Kevin
K> [EMAIL PROTECTED]
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is
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
Hello,
I am using the now() function to insert the current timestamp in a mysql
table.
My problem is that the server is using EST while I would like the time to
reflect PST.
Can this be done?
Thanks.
--Kevin
[EMAIL PROTECTED]
ch 29, 2002, 1:16:03 PM, you wrote:
DN> Hello Maxim,
DN> There's a bit of confusion in this discussion: Do you (a) want to have
DN> several databases running on the db-server, and all set to different
DN> time zones, or (b) want each client to see db-stored times stated in
DN>
Hello Maxim,
There's a bit of confusion in this discussion: Do you (a) want to have
several databases running on the db-server, and all set to different
time zones, or (b) want each client to see db-stored times stated in
his/her local timezone?
(a) AFAIK (and I claim no special expertise
Depends on the language you are writing in, and the level of your
programming skills.
If your users/guests have database entries, it would be a rather trivial
task to set their timezone in a column in the database, then write your app
to calculate their local time based on the offset from GMT
contains ~2 lines of code, and somewhere near to 1000
queries).
If someone knows how to play this around - please help!
Friday, March 29, 2002, 3:02:57 AM, you wrote:
GRJ> Per client? Per database? The only timezone setting in the MySQL manual is
GRJ> for the server (tz), and permits you to
contains ~2 lines of code, and somewhere near to 1000
queries).
If someone knows how to play this around - please help!
Friday, March 29, 2002, 3:02:57 AM, you wrote:
GRJ> Per client? Per database? The only timezone setting in the MySQL manual is
GRJ> for the server (tz), and permits you to
Per client? Per database? The only timezone setting in the MySQL manual is
for the server (tz), and permits you to set it to your local timezone so it
does not return values in GMT.
If you want clients to have different timezones, perhaps you should write
that capabilty into your front-end
Hello mysql,
So nobody here (even at MySQL AB) knows how to set a timezone for a
MySQL client ? Not for whole server but per client? (or maybe for
database???)
I already posted this question here few days ago - and didn't get any
reply.
Please! Somebody help!
--
Best regards,
>Description:
After setting the TZ environment variable to a different timezone, then
using the UNIX_TIMESTAMP(...) function on a mysql timestamp string brings back the
correct time, but a date that is a day out, but only for certain dates. It seems that
the date becomes the original date p
Hello 'mysql,
Does anybody know is this possible to set some particular timezone for
the session? ie: server is in GMT, but application needs time selected
in GMT+3
Is there any universal way ?
Thanx for any hint in advance
--
Best regards,
Maxim mailto:[
Hi folks -
I am still having 2 related problems with the timezone setting for mysqld &
was hoping to get some help.
Basically my squestions are as follows:
a) the documentation says to set timezone by simply using --timezone=# when
starting mysqld - but WHAT are the valid number values &am
Hi folks -
I am still having 2 related problems with the timezone setting for mysqld &
was hoping to get some help.
Basically my squestions are as follows:
a) the documentation says to set timezone by simply using --timezone=# when
starting mysqld - but WHAT are the valid number values &am
Hi folks -
I am having 2 related problems with the timezone setting for mysqld & was
hoping to get some help.
Basically my squestions are as follows:
a) the documentation says to set timezone by simply using --timezone=# when
starting mysqld - but WHAT are the valid number values & wh
> >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
y I deal with it (and I don't know that it will help you) is that I
store datetime as an integer from time() GMT. Then in the report I convert
the time to the correct timezone based on the user's IP (internal network,
different subnets for different TZ/locations). Of course this is a bad
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 c
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 reports from a company in that timezone.
This is the rollup SQL que
> > 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 INNO
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_
1 - 100 of 110 matches
Mail list logo
