Re: [PHP-DB] Returning a formated dat

2001-02-02 Thread Paul DuBois
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

Re: [PHP-DB] Returning a formated dat

2001-02-02 Thread Robert
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

Re: [PHP-DB] Returning a formated dat

2001-02-02 Thread Adam Younce
-- 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:

[PHP-DB] Returning a formated dat

2001-02-02 Thread Ben Cairns
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: [