[thelist] should I use unix timestamps instead of mysql timestamps

[Dunstan Orchard]

Hello everyone,

This might sound a bit obvious, but I wanted to ask before I did it :op


I'm using mysql timestamps in my msql db to automatically register the time at
which a record was created. The _only_ thing I use those for is to pull them
out and convert them into unix timestamps to perform comparisons with the
current time (also a unix timestamp).

I since discovered that I can have mysql insert unix timestamps instead of
it's own when creating a record - so I'm wondering if that's what I should be
doing, instead of all this conversion malarky.


There's nothing waiting to bite me on the backside if I go ahead and only use
unix ones is there?


Thanks very much for any advice,

- dunstan

---------------------------
Dorset, England
http://www.1976design.com/
http://www.orchard.it/
http://www.maccaws.org/