Re: Easy News Script
| From: | Christian Reiniger | Date: | Fri, 13 Apr 2001 10:59:43 +0000 |
| Subject: | Re: Easy News Script | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-48431@lists.php.net to get a copy of this message | ||
On Friday 13 April 2001 04:36, you wrote:
> It's easy once you get the hang of it.
>
> I use:
>
> // Format of MySQL DATETIME timestamp.
> $time = date("Y-m-d H:i:s");
>
> $time is ready for insertion into MySQL. To get the time out though
> you'll need to use the unix timestamp function in mysql.
Using MySQL's NOW() function is a bit easier :)
> That's a bit tougher to get the hang of :)
SELECT FROM_UNIXTIME(time_field) AS foo FROM mytable;
--
Christian Reiniger
LGDC Webmaster (http://sunsite.dk/lgdc/)
"The number of Unix installations has grown to 10, with more expected."
-- The Unix Programmer's Manual, 2nd Edition, June 1972