Select TIMESTAMP(date_column) AS mydate
Then when you display it use the date function
DATE('mdY',mydate)
-----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
