Jump to content

Most accurate format to store time in database for comparison


OldWest

Recommended Posts

I am just curious on some recommendations for the best format to store time in a table for later date comparison.

 

I was thinking time() is probably the best method as it store in epoch seconds I believe, and that can be formatted with date() easily, but I also heard this is not always accurate.

 

Please tell me any recommendations on this!

And suggestions or ideas on this?

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.