Format Dates In MySQL

Posted:

Sunday, November 27th, 2011

Last modified:

Sunday, March 29th, 2015

Topics:

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.

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

Available Wiki Topics

@TODO	chrome	Excel	ls	Photography	sysconfig
acpi	Composer	extensions	lsof	PHP	Tar
AJAX	Compser	file system	Mamp	PhpStorm	Taxonomy
Algorithms	Cookies	Firefox	math	Plesk	TCP
Android	CoreAudio	FTP	Module Development	Postgresql	Tests
angular	Coverage	Git	mod_rewrite	Programming	Theme Development
angular-1.x	cron	Gnome	MongoDB	Python	This wiki page is incomplete
Ansible	CSS	grep	Mothership Theme	Queues	Time and Date
Apache	cURL	Gunzip	MySQL	Rackspace	Tomcat
APT	Cygwin	gzip	mysqldump	Rails	Typography
Aptana	Data Structures	Hardware	Networking	React	Ubuntu
Arrays	Database	htaccess	NFS	REHL	vagrant
Backups	Debug	HTML	Nginx	RSpec	Variables
BAM	Demonstrations	HTTP	ngrok	Ruby	Views
Bash	dev tools	Ignore	Node	Sass	Views Data Export
benchmarking	Devops	images	Nodequeues	SCP	VirtualBox
Bitbucket	dig	Intellij	Not fully tested	Security	VirtualHosts
Blocks	directivess	iptables	npm	sed	wget
Bower	Drupal	Jasmine	nvm	SQL	Wiki
Caching	Drupal5	Java	OOP/D	SSH	Win7
cat	Drupal6	Javascript	OSX	SSHFS	WordPress
CDbCriteria	Drupal7	Jest	OSX Server	Strings	WWW
CentOs	drush	jQuery	Pagination	Sublime Text	XAMPP
CentOs5	Editors and IDEs	kill	Pantheon	Surviving Obsolescence	Xdebug
CentOs6	EPEL	Legacy	PDO	Syntax	Xfce
CGridView	errors	Links	Performance	sysadmin	Yii
Charsets	ES6	Linux	perl

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.