[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