I'm pulling data from a database, and there are dates in this format:

2011-08-05 03:52:00

how can I drop the specific time at the end in so it's just the date? I'm not sure if I should do this in VFP or SQL Server.