[thelist] SQL DB-Agnostic Date Storage

gabriel rivera evolt at protocol0.com
Wed Feb 5 11:42:01 CST 2003


Say you wanted to create a db schema that will uses no sql proprietary to
any particular database engine. (Which has been a requirement for my current
CMS project.)

So far my approach has been to use int for time fields, and storing all
times as unix epoch time.

Then, on the scripting side, I've had to convert to and from utime for every
db query.  No stress in PHP, but slightly less than elegant in classic ASP.

Anyone familiar with a better solution?

=Gabriel


>> So, what format do I store the thing in?
>
> date
>
> http://www.mysql.com/doc/en/DATETIME.html
>
>
> rudy




More information about the thelist mailing list