Why is the mySQL timestamp not in UTC time?

Asked by:
RonWon / 23 Points
Time:
2012-07-29 1:03 pm EST
Category:
Databases
Hits:
1,390
When I use the mySQL column timestamp and set the attribute to current_timestamp. The timestamp is in a different timezone then UTC? Why is this?

To ask this user for more information, please first login.

To submit an answer, please login.

ANSWERS

0

ScottM
Staff
13,027 Points
2012-07-30 10:45 am EST
Hello RonWon,

The attribute current_timestamp is not set to utc, but is a synonymn for the now() command, giving the datetime set on the server, which is either EST/EDT or PST/PDT for the US. MySQL does have a utc_timestamp attribute you can use instead.

Best Regards,
Scott M

To submit a comment on this answer, please first login.

Want to share this Question?

Related Articles

It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!

Help Center Search

Current Customers

Email: support@WebHostingHub.com Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.)
Chat: Click To Chat Now

Ask the Community

Get help with your questions from our community of like-minded hosting users and Web Hosting Hub Staff.

Not a Customer?

Get web hosting from a company that is here to help.