See the mysql manual - there's a section that deals with date/time functions
already built into mysq that work perfectly with timestamps
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Fun
ctions
jason
----- Original Message -----
From: "Dallas Kropka" <[EMAIL PROTECTED]>
To: "PHP LIST" <[EMAIL PROTECTED]>
Sent: Wednesday, January 17, 2001 9:20 AM
Subject: [PHP] Working with time()...
>
> in my database, all entries have a timestamp.... I need a way to brake the
> entries up and sort the entries:
>
> by year
> by month according to year
> by day according to the month
> and preferably by hour according to the day...
>
>
> How do I do this? Are there functions floating around the net that will do
> this?
>
> thanks.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
