Format Dates In MySQL

Last modified: 
Sunday, March 29th, 2015

Format Unix Timestamp as RFC-822 Date-Time

Where t1.timestamp is a unix timestamp to be converted to the form Wed, 02 Oct 2002 08:00:00 EST.

  DATE_FORMAT(FROM_UNIXTIME(t1.timestamp), '%a, %d %b %Y %T EST') AS formatted_date 
  FROM t1;

The operator of this site makes no claims, promises, or guarantees of the accuracy, completeness, originality, uniqueness, or even general adequacy of the contents herein and expressly disclaims liability for errors and omissions in the contents of this website.