madisonpark

Registered
Oct 20, 2012
1
0
1
cPanel Access Level
Website Owner
Hi,

Hope someone can assist.

We have a website that rents properties and we like to show the date the property is available. All the property details are in SQL and one of the fields is Availability date. The date is selected using calendar date picker but it always shows the date backwards for example: -

1st July 2013 shows as 2013-07-01

we have accessed the sql database through Cpanel and tried to amend the structure of the field and how it diplays as we want it to show in a UK format i.e.

01-07-2013

but whatever we do, it always reverts back to the original format. How do we change this so that the date is in the format we want?

Thanks