[dev] RDO setTimestamps

Karsten Fourmont fourmont at gmx.de
Wed May 3 04:30:27 PDT 2006


Duck wrote:
> I see that RDO automatically handles creation and update time of a row.
> But why use unix timestams rather than the SQL NOW() function, So we can deal 
> with dates not with intigers? As SQL has date dedicated function, it will be 
> much easier to deal with them.

I personally prefer using integers: I had lots of bad experiences with 
SQL DATE types: some databases tend to return dates in format like 
"02.11.2007" or "11/02/2007" depending on the locale setting in the 
database. So you end up doing a lot do decoding and encoding. It's OK if 
your database wrapper does that reliably but a small nightmare if not.

just my two cents. My experience is roughly 7 years old, so maybe we're 
living in a better world by now ;-)

Cheers,
  Karsten




More information about the dev mailing list