Mailing List Archive


Back to the month index Back to the list index
Gary Bickford (garyb@fxt.com)
Sun, 1 Sep 1996 23:13:51 -0700 (PDT) 

Date: Sun, 1 Sep 1996 23:13:51 -0700 (PDT)
Message-Id: <v01540b06ae4fc32a11d1@[204.245.248.245]>
From: garyb@fxt.com (Gary Bickford)
Subject: Re: [mSQL] Msql and DATE fields...

This went around the php-list about a month ago. Consensus was to use an
integer field. Opinion was mixed between using YYYYMMDD (19960831) or just
the unix time, recently in the range of 841643465.

In my experience since then, with both, I found messing with the YYYYMMDD
to be a pain in the behind. PHP has tools for converting to and from the
unix time() form, so it's much easier.

I considered dividing the value by 10, thereby going to 10 second
increments and extending the lifetime to (a long time from now, I'm sure) -
then I thought, "the heck with it." Much like the more mediocre COBOL
programmers of 1962. :)
Besides - it'll give my grandkids something to work on.

        | end
      --+-- Gary Bickford <garyb@fxt.com>
        | FXT Corp. / Informat Communications
        | 541-923-3060
        | fax 541-923-5537

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!