Sql Server Equivalent of Trunc
Trunc(Ld. Fecha_Crea) I Need Convert It to Sql Server 2 2 Answers You Can Use Following Condition in Your Query: Convert(Datetime, Convert(Date, Ld...
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:
Maya is a hardware enthusiast who tests and reviews smart home devices, smartphones, wearables, and audio gear. She focuses on practical consumer value and build quality.
