← Back to team overview

maria-discuss team mailing list archive

New Question: Converting unix timestamp stored as bigint to readable date time



A new question has been asked in "MariaDB Documentation" by thanmaya. Please answer it at http://mariadb.com/kb/en/converting-unix-timestamp-stored-as-bigint-to-readable-date-time/ as the person asking the question may not be subscribed to the mailing list.

We are storing the timestamp as a bigint. In the SQL query trying to convert this timestamp to date time.

have used the function FROM_UNIXTIME but it just returns a NULL value. 

To view or answer this question please visit: http://mariadb.com/kb/en/converting-unix-timestamp-stored-as-bigint-to-readable-date-time/