SQL Server equivalent of Trunc

TRUNC(LD.FECHA_CREA) 

I need convert it to SQL Server

2 Answers

You can use following condition in your query :

CONVERT(DATETIME, CONVERT(DATE, LD.FECHA_CREA)) = CONVERT(DATETIME, CONVERT(DATE, GETDATE())) 

You could use this equivalent in SQL Server:

CONVERT(DATETIME, CONVERT(DATE, LD.FECHA_CREA)); 

Check: