Unix Timestamps

[Jeremy]

I've been looking though "MySQL" by Paul DuBois (second edition) and the 
MySQL docs at http://www.mysql.com/doc/en/Date_and_time_functions.html 
(and others).

I'm looking for a MySQL function that returns the unix time (second 
since epoch), and there doesn't seem to be one.

Using a PHP script, what's the best way to store the current time (for 
example, when a message board post is made) so it can be easily read 
back and formatted later? I need to be able to use either MySQL's 
fucntions or the PHP date functions to format the date like "Tuesday, 
Feb 17, 2004 9:18:30pm".

Thanks..

Regards,
         Jeremy
--

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Jeremy Booker - Owner / Webmaster
JTech Web Systems
www.JTechWebSystems.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"Therefore do not worry about tomorrow, for tomorrow will worry about
itself. Each day has enough trouble of its own." -Mathew 5:34


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]