Hi,

You could use the Convert function to convert the date into the format required...

Convert(Varchar(10),getdate(),111) will convert the date into the yyyy/mm/dd format and you can then use :

SELECT RETUDATE FROM SVC05000 WHERE

RETUDATE = CONVERT(Varchar(10),getdate(),111)

further info on Convert can be found in BOL