About Us   SSWUG Articles   Articles   FAQ   Administration   Backup/Restore   Connectivity   Development   General   Installation   OLAP   Replication   Transfer/move   Trouble   SQL 6.5   Scripts   Tips   Test Exams   Advertise   Download   History   Search   Traffic   Related Links         Add to Favorites

How can I select only date/time part of a datetime value? Answer: --to select date part only SELECT CONVERT(char(10),GetDate(),101) --to select time part only SELECT right(GetDate(),7)

Visit The SQL Server Worldwide User's Group for all the latest news and information about SQL Server, Oracle, DB2 and XML for developers and administrators. (c) 1997, 2005 Bits on the Wire, Inc