Comments on snippet: 'from_unixtime sql' Snipplr comments feed https://ipv6.snipplr.com/ Tue, 07 Apr 2026 14:24:06 +0000 stavelin said on 11/Sep/2008 https://ipv6.snipplr.com/view/8315/fromunixtime-sql <p>the "FROM_UNIXTIME(published_date, '%d/%m/%y %H:%i') as published_date" is what I wanted to save, and remember. I always store dates as unix timestamp, somehow I feel this give me more flexibility, but I guess that's just me..</p> Thu, 11 Sep 2008 09:33:40 UTC https://ipv6.snipplr.com/view/8315/fromunixtime-sql