Data Browser - Viewing Site  Sector 23 Code Bank Logged in as:  Guest  




           


How to Truncate a SQL Server DateTime
This function will remove the time from a datetime 'MY_DATE_FIELD' in sql server:

dateadd(dd,0, datediff(dd,0, MY_DATE_FIELD))

Created By: amos 9/24/2010 11:08:38 AM