[thelist] date time calculation query

Hassan Schroeder hassan.schroeder at gmail.com
Tue Sep 20 17:56:47 CDT 2011


On Tue, Sep 20, 2011 at 3:29 PM, Renoir Boulanger <renoirb at gmail.com> wrote:

> In fact, as I recall, this is the common ground fordates on every POSIX
> compliant system and to my opibion the best way to store a date.

Unless you have dates prior to 1970, of course :-)

> Generally PHP lets you use it with strftime and the modifier "U".

Or just leave it to the DB, e.g.

unix_timestamp(now()) between membership_start and  membership_end

H*
-- 
Hassan Schroeder ------------------------ hassan.schroeder at gmail.com
http://about.me/hassanschroeder
twitter: @hassan


More information about the thelist mailing list