Re: formatting a timestamp
| From: | Gürhan Özen | Date: | Mon, 02 Jun 2003 01:49:30 +0000 |
| Subject: | Re: formatting a timestamp | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-28198@lists.php.net to get a copy of this message | ||
Rick,
Please give more information about your problem. Are you trying to
format a timestamp field in a MySQL table?
If yes, you can do something like,
SELECT DATE_FORMAT( columnname, '%m-%d-%y : %T-%i' );
Hope this helps...
Gurhan
On Sat, 2003-05-31 at 01:38, Rick Dahl wrote:
> I want to print out a timestamp of length 14. I want to have it formatted
> like:
>
> mm-dd-yy : hh-mm
>
> I have looked but all I can find is how to format a date and I don't want
> that. I want the time also.
>
> Rick
>
>
>
> "Don't burn the day...away" ~ DJM
>
> _________________________________________________________________
> Add photos to your messages with MSN 8. Get 2 months FREE*.
> http://join.msn.com/?page=features/featuredemail
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>