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 the
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 wi
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 nee
using 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] R
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
Hi,
Can we make adjustments in mysql or php code to display time in php sites
in EST , although server runs on CDT ?
Thanks
; To: mysql@lists.mysql.com
> 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 suppo
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
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.
DATE
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,
--Dave
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
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 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
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:
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
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 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
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
ernative you could set all your servers to use GMT
> > time, regardless of the geographical 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 ha
your servers to use GMT time, regardless
of the geographical 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 d
* 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.
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
zone'
RL> Egor Egorov 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
m, 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, but when I do that, the "select now()" advances 4
>RL> more hours.
>
>RL> Below is the
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
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()" ad
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 tim
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
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
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 to
33 matches
Mail list logo
