Cacher is the code snippet organizer for pro developers

DECLARE @fechaInicial DATETIME
DECLARE @fechaFinal DATETIME


IF @fechaInicial IS NULL BEGIN

 SET @fechaInicial = DATEADD(day,DATEDIFF(day, 0, getDate()),-1);
 SET @fechaFinal = DATEADD(day,DATEDIFF(day, 0, getDate()),0);

END

SELECT @fechaInicial,@fechaFinal

	SELECT dateadd(dd, datediff(dd,0, getDate()), 0);	
	--Truncate time
	dateadd(dd, datediff(dd,0, <fecha, DATETIME,getDate()>), 0)
	--Truncate hour
	CAST((CONVERT(varchar(10), <fechaInicial, DATETIME,getDate()>,103) + ' ' + CONVERT(varchar(3), <fechaInicial, DATETIME,getDate()>,114) + '00:00') as DATETIME)
	
	SELECT 
    	CONVERT(varchar(10),<fecha, DATETIME,getDate()>,103)															                as 'dd/MM/yyyy',
    	CONVERT(varchar(8),<fecha, DATETIME,getDate()>,114)															                    as 'HH:MM:ss',
    	CONVERT(varchar(10),<fecha, DATETIME,getDate()>,103) + ' ' + CONVERT(varchar(8),<fecha, DATETIME,getDate()>,114)				as 'dd/MM/yyyy HH:MM:ss',
    	CONVERT(varchar(10),<fecha, DATETIME,getDate()>,112) + '_' + REPLACE(CONVERT(varchar(8),<fecha, DATETIME,getDate()>,114),':','')as 'ddMMyyy_HHmmss'
	
	--Rango 
	--Fecha INicial Hora 00:00
	--Fecha Final   Hora 23:59
	BETWEEN DATEADD(day,DATEDIFF(day, 0, <fechaInicial, DATETIME,getDate()>),0) AND DATEADD(day,DATEDIFF(day, 0, <fechaFinal, DATETIME,getDate()>),1)
	
	--STR_ddMMyyyy hhmmss
	CONVERT(varchar(10),<fecha, DATETIME,getDate()>,103) + ' ' + CONVERT(varchar(8),<fecha, DATETIME,getDate()>,114)
	--STR_ddMMyyyy
	CONVERT(varchar(10),<fecha, DATETIME,getDate()>,103)
	--STR_hhmmss
	CONVERT(varchar(8),<fecha, DATETIME,getDate()>,114)