Hello,

in my web application, i insert use the getDate() function in sql to insert the dates into the database.
They are stored as '2005/07/29 14:16:19'

now i need to select records between 2 dates from the table.

the format the user will select is DD/MM/YYYY

what is the best way to convert this inside my sql statement so that sql server recognises it as yyyy/mm/dd

or do i need to change it in my code?

cheers