> Any of you MySQL heavyweights use UNIX_TIMESTAMP, UNIX_Date... or do you
> just use the MySQL Date/Datetime datatypes?
>
>
> I'm fairly new to MySQL, but I have an associate who insists that
> storing dates as int(11) using UNIX formats uses less disk space, and
> that we should always do this. The situations we're talking about
> involve less than 1000 records so I don't see it being worth the
> trouble. Opinions?
>
When I use mySQL I usually avoid unix timestamps because then you need
to use db specific functions like unix_timestamp. I'd rather keep my
applications as database platform independant as possible. 1000 records
is not going to take up too much diskspace any way you slice it.
___________________________________________
Pete Freitag
http://www.cfdev.com/
Author of the CFMX Developers Cookbook
http://www.petefreitag.com/bookshelf/
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
