Timestamp and datetime values, how to clean this mess !

  • Hi, I m using WordPress 4.3.1 with last buddypress version.

    I use some extensions to exports to csv my meta users, and that’s by analysing these informations today, that I saw I ve got some troubles with date values.
    Indeed, I have some dates values which are in timestamp format (1223769600 , -256608000) and some others in classic datetime YYYY-MM-DD 00:00:00 (that’s this one I want cause it’s readable).

    I tried an sql update with this request :
    Update wp_bp_xprofile_data SET value = FROM_UNIXTIME(value)where field_id=11

    It works for all the timestamp values, it converts it to the corresponding datetime.
    But for all the values wich where in correct datetime format, they all are now set to 1970-01-01 … :-/

    I don’t know what to do.
    Is there a way to convert only the values wich are in timestamp format ?

    Thanks per advance for your help… (and hope my english was understandable ;-))

  • The topic ‘Timestamp and datetime values, how to clean this mess !’ is closed to new replies.