SQL query to get date whatever the format it is inserted in database?

Hii,,
I am using custom format to store the date in the database .It should be stored in this form MM/dd/yyyy. I have to retrieve the results based on the date.My table looks like this:
Id           &nbs ...