TO_DATE function on query editor window

jkell

I am using an input tool that is connected to a database via an ODBC. Next I use the SQL editor window to write a simple query that uses a TO_DATE function in the where clause.

Issue: Whenever I open the query editor, the TO_DATE get converted to "TO_DATE". The quotations cause a syntax error if I don't remove them. This just recently started to happen (probably within the last month) so not sure what changed. Its an easy fix, but it is starting to get annoying.

Please advise, thanks!

rzdodson

Unsure what the origin may be of hte error, but I think you can resolve this with a CAST function within your SQL code to at the initial variable level within your query. For instance, something like:

SELECT TOP (100)

CAST(db.[yourdatefield] as datetime) as 'Custom Date'

FROM yourdatabase as db

This will convert the field to a DateTime field that can be handled like a traditional DateTime field in Alteryx.