Page 1 of 1
timestamp or date?
Posted: Thu Feb 10, 2005 9:56 pm
by pleigh
hi there,
in a forum-like page, what do you guys recommend to use to track the dates of logins and posts?timestamp or date?
thanks.
pleigh
Posted: Thu Feb 10, 2005 10:13 pm
by anjanesh
datetime.
timestamp will automatically update the time if you update any other field in the table. Therefore if you dont want the time to be updated each time you update a row, then you'll need to manually set the timestamp filed to NOW().
Posted: Thu Feb 10, 2005 10:30 pm
by feyd
I prefer binary timestamps i.e. int(11) .. basicaly stored unix-timestamp, versus the database's versions.. but I write for multiple architectures.. so...
Posted: Fri Feb 11, 2005 12:30 am
by pleigh
ok...thanks very much for your help guys
Posted: Fri Feb 11, 2005 2:53 am
by JayBird
Yes, i would also agree with feyd on using the UNIX timestamp