community
cancel
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

Meteor

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.

 

Cheers,

Labels