As Demitrious said, use mysql to do it. But if you want to use php, just use substr(), since all the numbers are there, there's no point converting to unix time, just to convert it back again... unless you're going to do some maths of it
-----Original Message----- From: Demitrious S. Kelly [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 9:51 AM To: 'Ragnar'; [EMAIL PROTECTED] Subject: RE: [PHP] Formating datevariables... Why not let mysql do it? It has a function do to exactly that, I think... But php's date() is the function you're looking for... -----Original Message----- From: Ragnar [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 4:42 PM To: [EMAIL PROTECTED] Subject: [PHP] Formating datevariables... I have a column in a mysql table with a timestamp. The value of this column is for instance: 20020722185242 How do i change the format on this to "DDMMYYYY" (22072002) in php? Thanx -R -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php