SQLServer DATETIMEOFFSET
25 November, 2013
Hello,
we're using in our SQL Server the type DATETIMEOFFSET, to log event created on computers worldwide.
YF does not recognize this native type, it treats it as VARCHAR.
How would you recommend to incorporate this field in YF?
Thanks,
Erez
we're using in our SQL Server the type DATETIMEOFFSET, to log event created on computers worldwide.
YF does not recognize this native type, it treats it as VARCHAR.
How would you recommend to incorporate this field in YF?
Thanks,
Erez
Hi Erez,
Unfortunately this is a limitation of Java. Java can only read a timestamp/date value , it does not handle a datetimeoffset value.
This is the reason why neither the Microsoft JDBC driver, or JTDS driver return it as a datetime format.
The only way to do this is to convert your datatimeoffset to a datetime and then use the Yellowfin timezone converter.
Sorry for the bad news, and please let us know how you go.
Regards,
David
Unfortunately this is a limitation of Java. Java can only read a timestamp/date value , it does not handle a datetimeoffset value.
This is the reason why neither the Microsoft JDBC driver, or JTDS driver return it as a datetime format.
The only way to do this is to convert your datatimeoffset to a datetime and then use the Yellowfin timezone converter.
Sorry for the bad news, and please let us know how you go.
Regards,
David