5/15/2007
Adding Human Readable Date to MySQL Query
SELECT *, FROM_UNIXTIME( 't_stamp_column') AS date FROM 'tablename'
For formatting the date see MySQL's date functions information.
Popularity: 19%
Stupidity cannot be cured with money, or through education, or by legislation. Stupidity isn't a sin, the victim can't help being stupid. But stupidity is the only universal capital crime; the sentence is death, there is no appeal, and execution is carried out automatically and without pity.
Robert Heinlein
Site Related
Search
Categories
AJAX
Apple / Mac
Broken
Data Architecture
Development
Dictionary
Dirt
Ecommerce
Economics
FreeBSD
General
Government
JavaScript
Lifehacks
Links
Linux
Microsoft / Windows
Open Source
PHP
Projects
Random Thoughts
Security
SEO
ShouldExist
Snippets
Software
SQL
SysAdmin
Technical
Travel
Check this out
- StreetViewSpy.com
Funny Google Maps StreetView snaps
- FreeNetDocs.com
Finding links to free internet docs
Subscribe
Sponsors
Buy LinksLatest Reads
 |
Ayn Rand: Atlas Shrugged |
 |
Neal Stephenson: Cryptonomicon |
 |
Jeremy D. Zawodny: High Performance MySQL |
Tip Jar
Links
