Displaying date from SQL database
Posted: Wed Jul 21, 2004 5:16 am
Dear All,
I have a date stored in a MySQL database which I am simply 'echoing' to display on my webpage. However, when I echo is, it displays in YYYY-MM-DD format, whereas I want it displayed in DD-MM-YYYY format, or even '23rd March 2004' format.
Can anyone tell me if it's a MySQL query syntax I need to use or a PHP function acting on the date?
Many thanks
Mark
I have a date stored in a MySQL database which I am simply 'echoing' to display on my webpage. However, when I echo is, it displays in YYYY-MM-DD format, whereas I want it displayed in DD-MM-YYYY format, or even '23rd March 2004' format.
Can anyone tell me if it's a MySQL query syntax I need to use or a PHP function acting on the date?
Many thanks
Mark