SQL Server equivalent of Trunc

Question

TRUNC(LD.FECHA_CREA)

I need convert it to SQL Server

possible duplicate of [How can I truncate a datetime in SQL Server?](http://stackoverflow.com/questions/923295/how-can-i-truncate-a-datetime-in-sql-server) — Dijkgraaf, Feb 03 '15 at 22:49

score 3 · Accepted Answer · answered Feb 03 '15 at 21:24

3

You can use following condition in your query :

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

answered Feb 03 '15 at 21:24

Hiren Dhaduk

score 1 · Answer 2 · answered Feb 03 '15 at 21:23

1

You could use this equivalent in SQL Server:

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

answered Feb 03 '15 at 21:23

Leandro Carracedo

2 Answers2