thanks it worked but shocking to know that the date format which is almost used in all forums for displaying is not supported by default in SQL.