Hiya,
Personally, I use the following bit of code. All it does is take a 14 digit
timestamp and convert it into a unix timestamp:
function date($date) {
//Extract the parts from the date
$year = substr($date, 0, 4);
$month = substr($date, 4, 2);
$day = substr($date, 6, 2);
MySQL has plenty of functions to return dates to you in any format you
specify. Please read
http://mysql.com/documentation/mysql/bychapter/manual_Reference.html#Date_and_time_functions
and pay special attention to the DATE_FORMAT() function.
-Rasmus
On Sun, 13 Jan 2002, Sander Peters wrote:
)?
Regards,
=dn
- Original Message -
From: Rasmus Lerdorf [EMAIL PROTECTED]
To: Sander Peters [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: 13 January 2002 19:52
Subject: [PHP-DB] Re: [PHP] convert /mm/dd to mm/dd/, how?
MySQL has plenty of functions to return dates
(and possibly in some situations, vice-versa)?
Regards,
=dn
- Original Message -
From: Rasmus Lerdorf [EMAIL PROTECTED]
To: Sander Peters [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: 13 January 2002 19:52
Subject: [PHP-DB] Re: [PHP] convert /mm/dd to mm/dd/