Conversion error in node Data Stream Out

[david2010]

Hi all,

I have a problem with my workflow loading data from db to alteryx (Data Stream Out says: Conversion failed when convertingdate and/or time from character string.). In the SQL statement (used in Connect In-DB) I'm converting string to date (see the following example/extract):

Select StartTime... from ... where convert(date,StartTime)>'2017-10-31 00:00:00'

Date format is like you can see 'YYYY-MM-DD HH:MM:SS'.

Does anyone has an idea what I'm doing wrong? 

[JohnGD · Accepted solution]

Hi @david2010!

According to this article, the CONVERT function accepts a 3rd optional argument "style" that specifies "the format used to convert between datatypes, such as a date format or string format"

In your case, I'd suggest the value 120, that corresponds to the format "yyyy-mm-dd hh:mi:ss".

Your query would be : Select StartTime... from ... where convert(date,StartTime,120)>'2017-10-31 00:00:00'

Let me know how it works.

John

[david2010]

Thank you John. That helped!

David