[CLUE-Tech] databases and timestamps ... 'since' idiom

[Jeffery C. Cann]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You could use the time_t timestamp - which is usally seconds since the epoch 
(jan 1, 1970).  So you would convert any date to a time_t timestamp (a large 
integer) and then do a numeric logical comparision to another converted date.

Usin SQL is very database dependant.  For example, Oracle has easy-to-use 
date comparision / manipulation functions.  MySQL automatically stores the 
timestamp of all records.  Which database are you using?

Jeff
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.4 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iEYEARECAAYFAjq0NcAACgkQw3/GBQk72kCmWQCcDM7G9rKliBEd3QeEwCXJVAwm
4wwAn0NFhgvqhl0sEOo+39KUmU9Q8X/O
=soXu
-----END PGP SIGNATURE-----