RE: [PHP] Date to string (with mask)
| From: | Filip de Waard | Date: | Sat, 08 Nov 2003 14:31:52 +0000 |
| Subject: | RE: [PHP] Date to string (with mask) | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-168955@lists.php.net to get a copy of this message | ||
On Sat, 2003-11-08 at 15:21, Christian Ista wrote:
> <?php echo mysql_result($result_cat,0,"CATC_DATE");?>
>
> a string like that : 2003-11-07 and I'd like display 07/11/2003
I usually do:
<?
$query = "SELECT UNIX_TIMESTAMP(datefield) as unixtime FROM table";
$timestamp = mysql_result($result, "unixtime");
$date = date("d/m/Y", $timestamp);
echo $date;
?>
Regards,
Filip de Waard