I am trying to trim or truncate a Date within my SQL 7 database to get rid of the Timestamp associated with it. The current format is - mm/dd/yyyy hh:mm:ss
I want it to look like - mm/dd/yyyy

Any suggestions?