SytelineMaster

SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE())) There is also a few useful UDF(User Defined Function) in Syteline ConvDate (@pInputDate  DateType, @pFormat   NVARCHAR(10)) Sample SELECT ConvDate(GetDate(), ‘MM/DD/YYYY’) Another useful one, DayEndOf ALTER FUNCTION [dbo].[DayEndOf] (   @Date DATETIME ) RETURNS DATETIME AS BEGIN     –  This function takes the input date and extends the time portion […]