Hi everyone,
Please help!
what's the correct syntax using DateFormat in SQL Server 2005.

Example. 05/04/07 00:00:00 i need this date show like this 05/04/07 i this regard the time.

Anyone who can help me this problems?