Converting Unix_Time to GMT in mySQL (1 post)

  1. DietCoke
    Posted 11 years ago #

    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?

Topic Closed

This topic has been closed to new replies.

About this Topic