Apologies for the vagueness of the query and I promise I've had a search (and will have another look in a minute!!) but i'm struggling with the following issue:
I've created a mysql database using phpmyadmin with primary key, date and news fields. For the date type I've tried a couple of different methods but find it displays incorrectly (year-day-month) and i'd like to change this to day-month-year. I downloaded an DW extension that had been used in a magazine article but it now displays all dates as 01/01/1970 so have hit a bit of a wall!
I'm a full on php noob so might struggle with the hard coding but am willing to have a go!!
Fortunately MySQL provides a powerful function named "date_format", so just have a look at http://www.dan.co.uk/mysql-date-format/ where you´ll find lots of well explained examples which utilize this function.
The third date formatting example (%d/%m/%Y) is already pretty close to the format you´d prefer, the only thing you´d have to do is replacing the forward slashes (/) with hyphens (-)
Change the date settings in ADDT Control Panel to the output format you want the dates to be in.
Then use the following to display it in that format:- (with the obvious changes for your recordset)
<?php echo KT_formatDate($recordset_name_here['db_date_column_here']); ?>