-
as seen on Server Fault
- Search for 'Server Fault'
I have several PostgreSQL 9.2 installations where the timezone used by PostgreSQL is GMT, despite the entire system being "Europe/Vienna". I double-checked that postgresql.conf does not contain timezone setting, so according to the documentation it should fallback to the system's timezone.
However…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hello,
In database I store all date/times in UTC.
I know user's timezone name ("US Eastern Standard Time" for example).
In order to display correct time I was thinking that I need to add user's timezone offset to UTC date/time. But how would I get timezone offset by timezone name?
Thank You!
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I build a Java TimeZone object using the TimeZone String like GMT-8,GMT,PST,EST etc.
This did not consider whether the timezone is daylight saving enabled or not.Now there is a requirement to include this check and instead of giving the input as PDT or EDT the daylight saving is given as a seperate…
>>> More
-
as seen on Super User
- Search for 'Super User'
To run my web app, I need to set my timezone to UTC on my MacBook. I can do this temporarily by opening a Konsole and entering
sudo ln -sf /usr/share/zoneinfo/UTC /etc/localtime
However, my timezone returns to normal when I restart my machine!
Any advice?
Edit : The response to this question…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hello
I have a spring/jdbc/oracle 10g application.
The Oracle server database timezone is set to GMT + 2 JVM timezone is GMT + 2 (even though it doesn't matter in my case).
I have a stored procedure that performs some date operations. The problem is that session timezone is different(GMT) than database…
>>> More
