> How does one cope with time zones? For example, if I want to timestamp a
> record it will timestanp using the local time of my server. I thought
that, > e.g if my server was in New York and my customer_location was the
UK, I
can > just add 5 hours to the time and it would be corr
Hello.
The good support of timezones is on TODO list. See:
http://dev.mysql.com/doc/mysql/en/todo-future.html
"Monty Harris" <[EMAIL PROTECTED]> wrote:
> How does one cope with time zones? For example, if I want to timestamp a
> record it will timestanp usin
How does one cope with time zones? For example, if I want to timestamp a
record it will timestanp using the local time of my server. I thought that,
e.g if my server was in New York and my customer_location was the UK, I can
just add 5 hours to the time and it would be correct.
While that might
I'm storing datetime values in UTC for an international site. Then
retrieving the data using 'select convert_tz(created, 'GMT','MST') from
table_name', so that the datatime appears in the correct local datetime
for the user. Does this method take into account daylight savings? If
not, how can t
Hi all-
I just downloaded and installed 4.1.3 on a WinXP environment. Does anyone
happen to have the data that should be loaded into all the new time zone
catalog tables? And the doc that describes the convert_tz() function and a
little more on general use of the time zone capability? My time zo
t;[EMAIL PROTECTED]>
To: "Graeme B. Davis" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, October 14, 2003 2:36 PM
Subject: Time zones and grouping
> Does anyone know any way to be able to group by day/week/month for an
> adjusted date (GMT -> EDT).
>
Message -
From: "Graeme B. Davis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 10, 2003 2:12 PM
Subject: Converting GMT stored data into other zones
| I was wondering if anyone had any tricks on the best way to handle
| localizing time zones in
EMAIL PROTECTED]
[EMAIL PROTECTED]
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 29, 2003 7:19 AM
To: [EMAIL PROTECTED]
Subject: Re: timestamps and time zones
"2Hosts.com" <[EMAIL PROTECTED]> wrote:
> Bearing in mind the internationa
"2Hosts.com" <[EMAIL PROTECTED]> wrote:
> Bearing in mind the international nature of the internet, how do I make a
> timestamp local to the user rather than local to my webserver in Canada? If
> a user is adding a record to my database from England, I want the timestamp
> to be GMT rather than PS
Bearing in mind the international nature of the internet, how do I make a
timestamp local to the user rather than local to my webserver in Canada? If
a user is adding a record to my database from England, I want the timestamp
to be GMT rather than PST, and the same for my Australian clients, and s
Hi everyone,
Apologies, I'm coming very late into this conversation, but perhaps I
can disperse some of the confusion...
Rob's original question:
*
I'm curious about how MySQL deals with time zones.
Our machines are located in the GMT time zone, and recently rolled over
to
B
I wrote:
> Using UNIX_TIMESTAMP() on a
> timestamp column will produce an epoch time (in seconds), but it
> won't necessarily be the right epoch time, because of daylight saving
> time (summer time) and possibly data that has moved from one time
> zone to another.
Actually the documentation
On 12 Apr 2002, at 14:01, Lance Uyehara wrote:
> > On 12 Apr 2002, at 13:05, Lance Uyehara wrote:
> > > UNIX_TIMESTAMP
> >
> > Maybe I'm missing something, but I don't think that's the answer.
> > How does UNIX_TIMESTAMP() know whether the timestamp is in summer
> > time (or even what time zone i
> On 12 Apr 2002, at 13:05, Lance Uyehara wrote:
> > > [EMAIL PROTECTED] wrote:
>
> > > It might be
> > > worthwile to have some way of retreiving a timestamp as an epoch value
in
> > > addition to other fifty ways you can currently retrieve it. (If there
> > > already is a way, I'd be thrilled to
On 12 Apr 2002, at 13:05, Lance Uyehara wrote:
> > [EMAIL PROTECTED] wrote:
> > It might be
> > worthwile to have some way of retreiving a timestamp as an epoch value in
> > addition to other fifty ways you can currently retrieve it. (If there
> > already is a way, I'd be thrilled to hear about i
We use a Network Time Server to keep the MySQL server in the right time.
-RG
On Fri, 12 Apr 2002, John Klein wrote:
>
> [EMAIL PROTECTED] wrote:
> >
> > As I understand it, the mysql TIMESTAMP type represents the time in your
> > local timezone (the one your computer is using).
> >
> > This make
> [EMAIL PROTECTED] wrote:
> >
> > As I understand it, the mysql TIMESTAMP type represents the time in your
> > local timezone (the one your computer is using).
> >
> > This makes it problematic to use in timezones that have a
summer/daylight
> > savings time. All of the date arithmetic functions
[EMAIL PROTECTED] wrote:
>
> As I understand it, the mysql TIMESTAMP type represents the time in your
> local timezone (the one your computer is using).
>
> This makes it problematic to use in timezones that have a summer/daylight
> savings time. All of the date arithmetic functions will yield
as I'm
>doing
> now with a portgresql dbase that supports a "timestamp with time zone" type.
>
> I would also be interested in any info anyone can provide on this subject. Thank you
> very much.
>
> Bradley
>
> Rob wrote:
>
> > I'm curious
rting schema from one dbase to another as I'm doing
now with a portgresql dbase that supports a "timestamp with time zone" type.
I would also be interested in any info anyone can provide on this subject. Thank you
very much.
Bradley
Rob wrote:
> I'm curious about how MySQL
I'm curious about how MySQL deals with time zones.
Our machines are located in the GMT time zone, and recently rolled over to
British Standard Time (local daylight savings time). The MySQL installation
has started returning NOW() values in local time, not GMT.
Is this the way the databa
Two more possibilities:
1. Set your MySQL server to use GMT for everything (that is, in the
OS, not in MySQL).
2. Store all times as Unix time (seconds since 1970) -- the
UNIX_TIMESTAMP() function can be useful for this.
Either solution still has the problem of converting to another forma
issues) onto the computer's
shoulders!
*** for the benefit of enquiring minds: the two places are in separate
time zones!
Please call back if I haven't addressed/anticipated all of your issues,
=dn
-
Before posting, ple
What's the best way to timestamp records if records are to be exported and
then re-imported to another web server in a different time zone? Data will
be exported as comma delimited data. All of the combined records should
reflect the same instant in time, and not have the web site in California
24 matches
Mail list logo
