> 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 th
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 using the local time of my
Hi,
If I understand you correctly the this query should help you:
select
date_format(date_add(DateTime, interval 7 hour), "%Y%m%d") as Date,
count(1)
from Table1
group by Date
order by Date
Best regards,
Mikhail.
- Original Message -
From: "Graeme B. Davis" <[EMAIL PROTECTED]>
To:
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
British Standard Ti
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 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 inaccurate
results if one of the date
I would like to second this notion if I may.
I was up until midnight (EST) last night trying to come up with the very same answers.
I found no answers from either the online mailing list searches nor from the O'Reilly
Mysql book... nor from the DBI book.
This also makes it difficult when porting s
13 matches
Mail list logo
