Best way to store timestamp

[unknowngiver]

Hey
whats the best way to store timestamp in the database?
Right now i have a field called timestamp, which is an int (11) and i get "time()" of the function performed and insert it into the database with the other information, but i am not sure if this is the right way of doing it. Thanks

 

[beaver6813]

As far as i know that is the best way to store the timestamp, then you can manipulate it anyway you want when retrieving it.

 

[unknowngiver]

in the TYPE column [when your adding a field] there is one called "TimeStamp" i just tried that..and if you check the "Timestamp" for the default value..it adds the date in this format :
2007-01-10 12:58:53
is it better?

 

[beaver6813]

No, just go with the PHP timestamp time(). If you're using this timestamp with PHP it is by far the best way to go as you can manipulate that timestamp once you retrieve it to whatever you want. ie. that long number could transform into 02/07/07 or even just into the time 13:21. The PHP timestamp time() is also more flexible and easier to manipulate :imho:

 

[TwistMyArm]

I would suggest using the proper MySQL timestamp but using the MySQL 'conversion' functions of UNIX_TIMESTAMP and FROM_TIMESTAMP. That way you deal with normal timestamps in PHP but by using those functions you can still store in the DB proper MySQL timestamps.

 

[baxter]

I've always just used the php function time() and int 11 but I guess its up to your preference I don't believe one has a significant speed/quality over the other.

 

[unknowngiver]

aight thanks i will go with time(); thanks :D