At 9:13 AM + 2/2/01, Ben Cairns wrote:
>I have a date stored in a MySQL field in a format like this:
>
>For example, 02/02/2001 (Today) would be stored as:
>02022001
>
>What I need to do is to format that so that it looks like:
>02/02/2001
I assume you really have this stored as a CHAR column
try:
$date=substr("$dat", 0,2)."/".substr("$dat",2,2)."/".substr("$dat",-4);
- Original Message -
From: "Ben Cairns" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 02, 2001 3:13 AM
Subject: [PH
--
From: "Ben Cairns" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 02, 2001 4:13 AM
Subject: [PHP-DB] Returning a formated dat
> I have a date stored in a MySQL field in a format like this:
>
> For example, 02/02/2001 (Today) would be stored as:
I have a date stored in a MySQL field in a format like this:
For example, 02/02/2001 (Today) would be stored as:
02022001
What I need to do is to format that so that it looks like:
02/02/2001
-- Ben Cairns - Head Of Technical Operations
intasept.COM
Tel: 01332 365333
Fax: 01332 346010
E-Mail: [