Hi, All when I insert the date in MySQL the format is 2009/07/13 and when I use SELELCT query it shows in the same format 2009/07/13. But I need to show in the Format 13-Jul-2009.
$result = mysql_query("SELECT Date FROM leaseentry WHERE SiteId REGEXP '$a'");
Please guide me.