In article <002f01c0b52b$d4778e00$[EMAIL PROTECTED]>,

> 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)


PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to