how to check the stored date is utc or local in l=mysql code example

Example: mysql date format unix timestamp

SELECT
  FROM_UNIXTIME(timestamp) 
FROM 
  your_table;