JDCam
asked on
MySQL Date format
PHPbb forum site hosted on a cloud server. I am extracting user data into excel through MySql in cPanel.
The datetime entries are stored numeric values (hash?) not sure how to get these in a usable format
For example value 1549909426 shows as Feb 11, 2019 1:23pm in the application
how can I either extract it as a usable date in MYSql or convert it once in excel
The datetime entries are stored numeric values (hash?) not sure how to get these in a usable format
For example value 1549909426 shows as Feb 11, 2019 1:23pm in the application
how can I either extract it as a usable date in MYSql or convert it once in excel
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you
ASKER