I dont know if its the "best" solution, but I made a function that "cut" the
date:

function sqldate($fecha) {
        
        $dia=substr($fecha,0,2);
        $mes=substr($fecha,3,2);
        $anio=substr($fecha,6,4);
        
        $fechasql=$anio."/".$mes."/".$dia;
        
        return $fechasql;
        
}

You input 12/01/2002 and output 2002/01/12!!!!


Fernando Bernain
Senior A
Business Process Outsourcing

KPMG Argentina
Tel: 54 11 4316 5754
Fax: 54 11 4316 5734
[EMAIL PROTECTED]




-----Original Message-----
From: Ali McLeod [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 04, 2003 8:27 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] displaying a MySQL date in a different format


Can anyone help me. I am trying to display a date in a different format from
that stored in a MySQL database. MySQL forces you to store it as yyyy-mm-dd
but I want to display it as dd-mm-yyyy, or dd-mmmm

Any ideas?

Many thanks in advance

Ali McLeod
[EMAIL PROTECTED]



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Email Disclaimer

The information in this email is confidential and may be
legally privileged.
It is intended solely for the addressee.
Access to this email by anyone else is unauthorised.
If you are not the intended recipient, any disclosure,
copying, distribution
or any action taken or omitted to be taken in reliance
on it, is prohibited and may be unlawful.
When addressed to our clients any opinions or advice
contained in this email are subject to the terms and
conditions expressed in the governing KPMG client engagement
letter.


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to