Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001072

RE: [PHP-DB] Date Format From: Michael Rudel (mru <email protected>)
Date: 07/20/01

Hi CK,

I always fetch the Date like "SELECT UNIX_TIMESTAMP(Timestamp) AS Timestamp"
so you can manipulate it with all the PHP Date- and Timefunctions like
date(). So you can display the date the way you asked with:

$Timestamp = ; // fetch the Timestamp the way you like =8)
echo date( "d-m-Y", $Timestamp );

Thats it.

Hope this helps.

Greetinx,
  Mike

Michael Rudel
- Web-Development, Systemadministration -

Besuchen Sie uns am 20. und 21. August 2001 auf der
online-marketing-düsseldorf in Halle 1 Stand E 16
_______________________________________________________________

Suchtreffer AG
Bleicherstraße 20
D-78467 Konstanz
Germany
fon: +49-(0)7531-89207-17
fax: +49-(0)7531-89207-13
e-mail: mailto:mru <email protected>
internet: http://www.suchtreffer.de
_______________________________________________________________

> -----Original Message-----
> From: system <email protected> [mailto:system <email protected>]On
> Behalf Of system
> Sent: Saturday, July 14, 2001 5:17 AM
> To: php-db <email protected>
> Subject: [PHP-DB] Date Format
>
>
> Friends,
> I have a design, up and running scripts connected to MySQL.
> How do I retrieve date formats and have it displayed as dd-mm-yyyy ?
> I store them as DATE.
> CK Raju
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe <email protected>
> For additional commands, e-mail: php-db-help <email protected>
> To contact the list administrators, e-mail:
> php-list-admin <email protected>
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>