Sql

[jacobelias]

I want to retrieve date in YYYY-MM-DD from date format
10th August 2003.

How can I get this?

Aun

[_UK_Stuffer]

Depending upon what DB you are using you can normally specify the format you require. Within MySQL a simple select statement would look like the following:-

SELECT DATE_FORMAT(DateColName, "%D %M %Y") FROM TABLE

Whilst when using MSSQL Server you would have to use a CONVERT statement. One thing that should be noted though is this is a server side process, slowing things down.

[Tigress7]

Try

$mydate=strtotime("10 August 2003");
$myformat=date("Y-m-d",$mydate);