at the top of your script, do: setlocale ( LC_TIME, 'de_DE' ) ; (assumes your machine has German support installed) HTH Ignatius _________________________ ----- Original Message ----- From: "Ruprecht Helms" <rhelms@xxxxxxx> To: <php-db@xxxxxxxxxxxxx> Sent: Wednesday, November 26, 2003 16:58 Subject: convert date in german format > Hi, > > how can I convert a date stored in a mysql-database for output > in the german format (dd.mm.yy). > > I tried date ("d.m.y",$row->from); > > but I still get the english-format stored in the database. > The databasefield is type date. > > Regards, > Ruprecht > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php