Here is the infor syteline 8.02 's self-defined function:
Copy Code code as follows:
Midnightof
ALTER FUNCTION [dbo]. [Midnightof] (
@Date DATETIME
) RETURNS DATETIME
As
BEGIN
Return (DATEADD (datepart, @Date), DATEADD (month, DATEPART (month, @Date)-1), DATEADD (DATEPART ( Day, @Date)-1), ' 2000 '))
End
Here's the book.
The method provided on page 86th:
Copy Code code as follows:
SELECT DATEADD (Day,datediff (Day, ' 20010101 ', current_timestamp), ' 20010101 ');
The following is a insus.net method that can only be applied to SQL Server 2008 or later because there are date and time data types in this version.
Version 1:
Copy Code code as follows:
SELECT Cast ((CAST (CAST (Current_timestamp as DATE) as CHAR) + ' + ' 00:00:00.000 ') as DATETIME)
Version 2:
Copy Code code as follows:
SELECT cast (CAST (Current_timestamp as DATE) as DATETIME)
