maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #03030
New Question: Converting unix timestamp stored as bigint to readable date time
Hello,
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/