[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