View previous topic :: View next topic |
Author |
Message |
ultraincognito Guru
Joined: 03 Jun 2011 Posts: 346 Location: Ukraine
|
Posted: Fri Jul 01, 2011 7:21 am Post subject: Many time zones in system |
|
|
I want use UTC for MySQL, but the localtime for other programs. Is it possible?
I live not in a first time zone. |
|
Back to top |
|
|
chithanh Developer
Joined: 05 Aug 2006 Posts: 2158 Location: Berlin, Germany
|
Posted: Sat Jul 02, 2011 1:53 am Post subject: |
|
|
You can set the TZ variable to override /etc/localtime. |
|
Back to top |
|
|
ultraincognito Guru
Joined: 03 Jun 2011 Posts: 346 Location: Ukraine
|
Posted: Sat Jul 02, 2011 3:48 pm Post subject: |
|
|
i use windows xp on my second partition and I don't use UTC time for BIOS. |
|
Back to top |
|
|
chithanh Developer
Joined: 05 Aug 2006 Posts: 2158 Location: Berlin, Germany
|
Posted: Sat Jul 02, 2011 3:57 pm Post subject: |
|
|
If by "other programs" you meant "other operating systems", then it gets more difficult. You can set Windows XP (but not Vista/7 iirc) to use UTC as the local time. But then of course your clock will be off.
Alternatively, there is a registry hack which will set the real-time clock to UTC while the local time is still shown correctly, but there are issues with it. |
|
Back to top |
|
|
ultraincognito Guru
Joined: 03 Jun 2011 Posts: 346 Location: Ukraine
|
Posted: Sat Jul 02, 2011 8:50 pm Post subject: |
|
|
Understood. I'll seek for an advanced watch for desktop. On your opinion is it good idea? |
|
Back to top |
|
|
iss Tux's lil' helper
Joined: 30 Oct 2006 Posts: 134 Location: Poland/Bydgoszcz
|
Posted: Mon Jul 04, 2011 2:23 pm Post subject: |
|
|
I'm not sure if understand you correctly but this might help - in /etc/conf.d/hwclock set
This way Gentoo will know system clock is set for local timezone (like in Windows).
For MySQL you can [url="http://dev.mysql.com/doc/refman/5.5/en/time-zone-support.html"separately set timezone[/url] of your liking. |
|
Back to top |
|
|
|