Hello Joe
On 4/5/2013 10:25 AM, Joe Kosinski wrote:
I have installed the community edition version 5.6 to my MacBook running
OSX 10.8.3. I am trying to set up MythTV backend which requires the
time zone tables to be loaded for the database I will be using.
I have not been able to load
Hi Joseph,
We request that except for sensitive information that you keep all
responses on the list. This way the entire community can kick in for
assistance.
On 4/5/2013 12:25 PM, Joseph Kosinski wrote:
Thanks for your response. This has been troubling me for days! I am
not too familiar
Hi All,
Someone posted this on this list just a few days ago:
Incorrect value for default-time-zone http://lists.mysql.com/mysql/215197
And I am now suddenly getting exactly the same issue. Nothing really changed
in the mysql department, I did install the latest OS X updates, and needed
mysql-bin
081113 15:24:43 [Note] Starting crash recovery...
081113 15:24:43 [Note] Crash recovery finished.
081113 15:24:43 [ERROR] Fatal error: Illegal or unknown default time zone
'GMT +08:00'
081113 15:26:57 InnoDB: Started; log sequence number 0 423199200
081113 15:26:57 [Note] Recovering after
Hi,
Can we make adjustments in mysql or php code to display time in php sites
in EST , although server runs on CDT ?
Thanks
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 , although
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 adjustments in mysql
CC: [EMAIL PROTECTED]
Subject: Time Zone Support
Date: Tue, 26 Aug 2008 22:26:36 -0600
Hi,
We need to add support for time zone to our existing PHP Board Member
Extranet applications. Could those of you with experience supporting a time
zone field in your MySQL data tables offer some
Hi,
We need to add support for time zone to our existing PHP Board Member
Extranet applications. Could those of you with experience supporting a time
zone field in your MySQL data tables offer some advice? Would you use a single
field? Would you use just an offset value? How would you
Hello All,
Indiana will move to EDT on April 2nd. I am concerned with MySQL DATETIME
stamps that I have stored in my systems and whether or not I need to restart
each MySQL daemon to ensure that it reads the correct system time and zone info.
Your help is greatly appreciated.
Regards,
At 9:38 -0500 3/28/06, Dave Juntgen wrote:
Hello All,
Indiana will move to EDT on April 2nd. I am concerned with MySQL
DATETIME stamps that I have stored in my systems and whether or not
I need to restart each MySQL daemon to ensure that it reads the
correct system time and zone info.
Hello.
This link might be helpful:
http://dev.mysql.com/doc/mysql/en/time-zone-support.html
Scott Haneda [EMAIL PROTECTED] wrote:
Is there a way to tell NOW() in mysql to be based on a time in the future?
Bascially, I am in PST, and they are in EST, I have a ton of reports
Is there a way to tell NOW() in mysql to be based on a time in the future?
Bascially, I am in PST, and they are in EST, I have a ton of reports that
show the time and date, and they want them in EST time, not the time the
server is in.
it is trivial to modify the display output of the time, but
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
we just upgraded from 4.0.4 to 4.1.3, and are getting this warning. is
there a script somewhere we can run to create the alleged missing time
zone table?
040804 10:09:49 Warning: Can't open time zone table: Table
'mysql.time_zone_leap_second' doesn't exist trying to live without them
thanks
To: mysql
Sent: 8/4/04 11:14 AM
Subject: time zone leap seconds
we just upgraded from 4.0.4 to 4.1.3, and are getting this warning. is
there a script somewhere we can run to create the alleged missing time
zone table?
040804 10:09:49 Warning: Can't open time zone table: Table
Is there supposed to be data loaded into the mysql.time_zone* tables? There
is none in the Solaris binaries nor the Win32 binaries. Is this a bug?
Does anyone know?
Thanks,
Rick
* 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 only
Hi,
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.
TIA.
Hassan
placement of the server. That way you would only need an
$usertimezone offset.
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.
Jochem
--
I don't get it
immigrants don't work
and steal our jobs
- Loesje
of the server.
That way you would only need an $usertimezone offset.
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
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
* 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 proper
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
Renato,
Tuesday, July 23, 2002, 9:40:35 PM, you wrote:
RL I have several mysql servers installed, all without TZ variable, one of
RL them, insists in set the select now() to 4 hours ahead of my internal
RL clock, first I touch that I should set TZ to my time time zone in
RL /etc/init.d/mysql
now() to 4 hours ahead of my internal
RL clock, first I touch that I should set TZ to my time time zone in
RL /etc/init.d/mysql, but when I do that, the select now() advances 4
RL more hours.
RL Below is the information about my system. now the --timezone option in
RL /etc/init.d/mysql nor
wrote:
Renato,
Tuesday, July 23, 2002, 9:40:35 PM, you wrote:
RL I have several mysql servers installed, all without TZ variable, one of
RL them, insists in set the select now() to 4 hours ahead of my internal
RL clock, first I touch that I should set TZ to my time time zone in
RL /etc/init.d
I have several mysql servers installed, all without TZ variable, one of
them, insists in set the select now() to 4 hours ahead of my internal
clock, first I touch that I should set TZ to my time time zone in
/etc/init.d/mysql, but when I do that, the select now() advances 4
more hours
On 29/4/02 at 11:01 pm, Scott Seidl [EMAIL PROTECTED] wrote:
I am still having problems with the time zone within Mysql. I change the
value of the TZ environment variable, and that change will show up in the
SHOW VARIABLES; query within mysql, but the actual time that is being
provided
Scott,
Monday, April 29, 2002, 1:46:09 AM, you wrote:
SS I am trying to get my time zone setup correctly with mySQL on a RedHat 7.2
SS box, so the select now(); query returns the correct time. The show variable
SS command show that the time zone is being updated with the different values I
SS
I am still having problems with the time zone within Mysql. I change the
value of the TZ environment variable, and that change will show up in the
SHOW VARIABLES; query within mysql, but the actual time that is being
provided by the select now(); is still not showing up correctly.
Please Help
I am trying to get my time zone setup correctly with mySQL on a RedHat 7.2
box, so the select now(); query returns the correct time. The show variable
command show that the time zone is being updated with the different values I
enter, but the time is still coming up 4 hours off. I am trying
32 matches
Mail list logo