Converting Unix_Time to GMT in mySQL

  • I’m trying a conversion to WP, and so far everything has gone ok mostly. However, I am having trouble within mySQL with the conversion field. The previous CMS (non-open source) stores the posts in Unix time, versus WordPress which seems to store in GMT(?).

    For example, one original post has a timestamp of 997162432. That translates into: Tuesday, August 7th 2001, 5:33:52 (GMT).

    What I’m looking for is the mySQL query that would translate the Unix timestamp to WordPress’s timestamp. Thus far I’ve found some documentation on how to do the opposite, but only on a per-post basis. As I’ve got about 4500 posts, that’s not really feasible.

    Any tips?

  • The topic ‘Converting Unix_Time to GMT in mySQL’ is closed to new replies.