tags:

views:

15

answers:

0
Q: 

mysql timezone and current_timestamp

Hi,

I have changed the timezone of my server per connection basis which is working fine

but most of the addedon Fields in my database tables and timestamp and I am using the CURRENT_TIMESTAMP default value for them to add the inserted date.

Now as I have changed the timezone but this change is not affecting the dateadded fields of my database table.

Please help.

Thanks Umar

related questions

Displaying Time Zones in WPF/C#. Discover Daylight Savings Time Offset
Should the timezone be a constant or a variable?
TZ Multiple TimeZone under Windows
How to convert UTC time to Time in any other time zone in C#
How to store a recurring time window
UTC Offset in PHP
Determine Time Zone Offset in T-SQL
How to display DateTime with an abbreviated Time Zone?
What is the best way to detect and store the timezone the client of a web app is in?
Apache configuration help -- Why are different processes "in" different time zones?
How to retrieve time zone choices on Windows Mobile for PDA
How would you organize a timezone dropdown?
How do I use timezones with a datetime object in python?
Best way to extract a timezone from a mail Date header in Java?
Best way to extract TimeZone object from a String?
How do I convert GMT to LocalTime in Win32 C?
Resetting detection of source file changes
Web service - current time zone for a city?
How can I determine whether a given date is in Daylight Saving Time for a given timezone in .NET 2.0?
Timezone lookup from latitude longitude
Setting time zone remotely in C#
Send out email at a user's local time.
Handling timezones in storage?
Java Time Zone is messed up
How can I determine a web user's time zone?