Henry Miller wrote:
On 8/1/2005 at 08:41 Puneet Kishor wrote:
I am curious about this as well... not about the various functions, but
what is, if at all, a better way to store the values -- as 'YYYY-MM-DD
HH:MM:SS' strings (are they not stored internally as just strings?) or
as unixepoch time (which would likely be stored as an int)?
Is not the latter (unixepoch) faster than the former ('YYYY-MM-DD
HH:MM:SS' strings)?
Is one more malleable than the other for conversion into various other
display forms as well as for DATETIME calculations?
This depends on what you want. There is no best for all situations.
Either form is convertible to the other.
that, I knew.
and the libraries were written by smarter people than you,
;-). That I didn't.
Make a choice and move on. This is one of those issues where it is
fairly easy to understand all the concerns, so people like to debate it
in depth to prove they are paying attention. Doing so is a waste of
time.
well, you answered my question in depth, and gave me enough fodder to
waste a bit more time thinking about it now rather than regretting later.
Many thanks for your detailed reply.
--
"measure twice, cut once"
