Welcome Guest, Not a member yet? Register   Sign In
'Best' date type: store as Unix timestamp or MySQL DATETIME?
#1

[eluser]Daniel H[/eluser]
Hi

I have always used DATETIME as the field type for any date related fields in MySQL. But now I'm working on a site that will have to do some timezone manipulations etc., so I will make great use of the date helper. However, I was wondering what was best practice... to store Unix formatted timestamps as, say, an INT(10) in MySQL, or do Unix/DATETIME conversions on the fly?

Bear in mind that I won't be using MySQL's own TIMESTAMP type.

Thanks,

Dan.




Theme © iAndrew 2016 - Forum software by © MyBB