Community Q&A:

Why is the mySQL timestamp not in UTC time?

Asked by:
RonWon / 23 Points Time:
2012-07-29 8:03 pm EST Category:
Databases Hits:
1,514
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
16,266 Points
2012-07-30 5:45 pm 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?

Help Center Login

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!
Need More Help?

Help Center Search

Current Customers

Ticket: Submit a Support Ticket
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.
}