I have MySQL 3.23 db with columns in which unix timestamp is stored. I want to convert these columns to datetime format (for human readability reasons).
How do I write the update call?
startstamp is the column with the UNIX timestamp
I made an extra column startdtg to hold the result, and then can delete the startstamp column when done.
I tried (and may be way off since it doesn't work).
Update Buyers set startdtg=FROM_UNIXSTAMP(startstamp)
How do I write the update call?
startstamp is the column with the UNIX timestamp
I made an extra column startdtg to hold the result, and then can delete the startstamp column when done.
I tried (and may be way off since it doesn't work).
Update Buyers set startdtg=FROM_UNIXSTAMP(startstamp)