Topic: Date type not reckognized in SQL Server 2008?
Date type not reckognized in SQL Server 2008?
I've tried both jTDS and official SQL Server jdbc driver, but all my date fields are reckognized as strings.
However, when I look on the "metadata" tab, it correctly states that native type is "date", but datacleaner's Type is "STRING".
Is this related to the fact that MS only recently introduced the Date type (before there was only DATETIME)?
Is there a workaround?
Thanks.
However, when I look on the "metadata" tab, it correctly states that native type is "date", but datacleaner's Type is "STRING".
Is this related to the fact that MS only recently introduced the Date type (before there was only DATETIME)?
Is there a workaround?
Thanks.
Hi,
Yes I think the reason might be that the date type is new. I will look if there is an update to JTDS to fix this, but in the meanwhile your workaround will be to use the "Convert to Date" transformer on your strings.
Yes I think the reason might be that the date type is new. I will look if there is an update to JTDS to fix this, but in the meanwhile your workaround will be to use the "Convert to Date" transformer on your strings.
Log in by clicking the login link at the top of the screen
Go back to forum.
