On Wed, 2008-10-15 at 12:08 -0400, Olaf Stein wrote:
> You can use the convert_tz function for this
> http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function
> _convert-tz
>
> On 10/15/08 12:03 PM, "Madan Thapa" <[EMAIL PROTECTED]> wrote:
>
> > Hi,
> >
> > Can we make adjus
You can use the convert_tz function for this
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function
_convert-tz
On 10/15/08 12:03 PM, "Madan Thapa" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Can we make adjustments in mysql or php code to display time in php sites
> in EST , alt
you'll need to set the datetime function before presenting date/time to the user
http://www.w3schools.com/php/func_date_default_timezone_set.asp
Martin
__
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to th
i seemed to have gotten around it by manually sourcing the script to
update the password field, which had the create table statements in it,
and then loading time zones based on our system time zone files. the
manual section on upgrading from 4.0 to 4.1 did explain this -- i just
had to dig a l
There is are five new time_% tables. You could install 4.1.3 in a clean
area, export the tables and import the tables into the upgraded environment.
You could also export your 4.0.x data and import this data into the newly
created 4.1.3 environment.
-Original Message-
From: Jeff Mathis
To
* Harald Fuchs
[...]
> > You could also store the number of halfhours.
>
> Nope. Chatham Island has an offset of +12.75 hours.
Yeah, and Kathmandu is +5.75 hours.
Better avoid customers from Chatham Island and Kathmandu, then... ;)
Seriously, I have implemented a timezone system once, but we on
Roger Baklund wrote:
* Jochem van Dieten
Functionally, I believe it is much cleaner as it abstracts the
problem away from the developer. Especially around DST changes
this can be an important issue.
I agree again. But it doesn't answer my question... I suppose you can live
without timezones untill
* Jochem van Dieten
> > Woudn't the "proper way" be the way that leads to a result you can live
> > with? Of course support in the server would have been better,
> > but why can you not use a mechanism as described above?
>
> Using AT TIME ZONE is the way supported by SQL:1999, which makes
> it the
Roger Baklund wrote:
* Jochem van Dieten
The proper way to program this would require MySQL to support the
AT TIME ZONE construct, but I haven't found it on the MySQL
roadmap yet.
Woudn't the "proper way" be the way that leads to a result you can live
with? Of course support in the server would ha
* Jochem van Dieten
[...]
> > The $usertimezone contains an integer between -12 and +12,
> > representing the offset in hours of the user timezone compared
> > to the server timezone. A user in the same timezone as the
> > server would have $usertimezone=0.
>
> Some locations have timezone offsets
Roger Baklund wrote:
The date/time returned by the server is in the timezone of the server. If
you need to convert it to a different timezone, you must do this within your
application. It can be done directly in the SELECT statement. PHP example:
$usertimezone = get_user_prefs('timezone');
$res = m
* Hassan Shaikh
> How do I change datetime from one time zone to another? I've a
> column in one of my tables having the type DATETIME and I need to
> show date AND time to end-user based on his/her preference.
The date/time returned by the server is in the timezone of the server. If
you need to c
12 matches
Mail list logo
