In article <002f01c0b52b$d4778e00$[EMAIL PROTECTED]>,
[EMAIL PROTECTED] ("[EMAIL PROTECTED]") wrote:
> I save the date in my MySQL db as 2001-03-25.
>
> But in my PHP script i want do see it like 25-03-2001.
Do it in the MySQL select. Assuming date_field is of field type 'date':
select date_format(date_field,"%d-%m-%y") as date_formatted from mytable;
(See the MySQL manual's section on date/time functions for more ideas)
--
CC
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]