Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

In-Datebase Method for DateTime to Date Conversion


I upgraded to 2018.4 (from 11.5), and I now get an error when I try to convert a DateTime to a Date in a database using trunc("[Date Field Name]",'day'). It says that trunc is not a built in function on the SQL server. Is there an alternative I can use while staying in the database? Thanks!

Alteryx Certified Partner
Alteryx Certified Partner

Hi @LSB123


As far as I know, Trunc is not applicable to SQL Server, only Oracle.


You could try CONVERT function, which is equivalent.