KNIME date import issue
My database stores all time measures as datetime. For my analyses, I need no more than date.
When I write the SQL statement in DB Query Reader, I use a line such as
CAST(Patient.Birth_DtTm AS date) AS DateOfBirth,
CONVERT(date, Patient.Birth_DtTm, 120) as DateOfBirth2,These commands return the correct date as a string, but not as a date.
Is there some way of returning the date as a date variable in KNIME rather than a string?
A