community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

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

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