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

[Dave Price]

I am using postgres right now, but a lot of my input data comes in as 
various delimited text files.

Is the time_t time format the same as a *nix time stamps?
Is there a core module that handles time_t, or do i need a CPAN module added?
One weird bit, I sometimes like to 'predigest' my text files a bit under 
active state for win32.


At 09:12 PM 03/17/2001 -0700, you wrote:
>-----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-----
>_______________________________________________
>CLUE-Tech mailing list
>CLUE-Tech at clue.denver.co.us
>http://clue.denver.co.us/mailman/listinfo/clue-tech