Date format stored in MySQL db is in EPOCH date/time format.
How does one go about converting into human date format using the SQL editor?
FROM_UNIXTIME(Epoch_date,"%Y-%m-%d") AS "Human_Date"
But alas it seems FROM_UNIXTIME is not part of SiSense SQL functions
And since I'm here...
"UNIX_TIMESTAMP" would convert from Human date to Epoch date.
Cheers & thanx.
Please sign in to leave a comment.