Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
Many time zones in system
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Other Things Gentoo
View previous topic :: View next topic  
Author Message
ultraincognito
Guru
Guru


Joined: 03 Jun 2011
Posts: 346
Location: Ukraine

PostPosted: Fri Jul 01, 2011 7:21 am    Post subject: Many time zones in system Reply with quote

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
View user's profile Send private message
chithanh
Developer
Developer


Joined: 05 Aug 2006
Posts: 2158
Location: Berlin, Germany

PostPosted: Sat Jul 02, 2011 1:53 am    Post subject: Reply with quote

You can set the TZ variable to override /etc/localtime.
Back to top
View user's profile Send private message
ultraincognito
Guru
Guru


Joined: 03 Jun 2011
Posts: 346
Location: Ukraine

PostPosted: Sat Jul 02, 2011 3:48 pm    Post subject: Reply with quote

i use windows xp on my second partition and I don't use UTC time for BIOS.
Back to top
View user's profile Send private message
chithanh
Developer
Developer


Joined: 05 Aug 2006
Posts: 2158
Location: Berlin, Germany

PostPosted: Sat Jul 02, 2011 3:57 pm    Post subject: Reply with quote

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
View user's profile Send private message
ultraincognito
Guru
Guru


Joined: 03 Jun 2011
Posts: 346
Location: Ukraine

PostPosted: Sat Jul 02, 2011 8:50 pm    Post subject: Reply with quote

Understood. I'll seek for an advanced watch for desktop. On your opinion is it good idea?
Back to top
View user's profile Send private message
iss
Tux's lil' helper
Tux's lil' helper


Joined: 30 Oct 2006
Posts: 134
Location: Poland/Bydgoszcz

PostPosted: Mon Jul 04, 2011 2:23 pm    Post subject: Reply with quote

I'm not sure if understand you correctly but this might help - in /etc/conf.d/hwclock set
Code:
clock="local"

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
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Other Things Gentoo All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum