โ07-26-2018 01:52 PM
Hi All,
Iโm trying to update the target sql server table using โsql server updateโ snap with the where condition โINSERTTS = $INSERTTSโ (INSERTTS is the insert date timestamp) but Iโm getting the error
Failure: Type class org.joda.time.LocalDateTime is not supported in dialect DEFAULT, Reason: Failed to execute SQL Server Snap, Resolution: Please address the reported issue.
The INSERTTS column in the source table has values in the format shown below
2014-07-22 15:56:13.000
2014-07-22 15:57:48.000
2014-07-22 15:58:34.000
2014-07-17 13:51:07.000
2014-07-22 16:00:05.000
2014-07-22 16:04:51.000
2014-07-23 06:26:40.000
2012-06-15 10:49:43.000
2012-06-15 10:56:20.000
2014-07-23 11:17:07.000
2014-07-22 14:16:01.000
2014-07-22 14:17:08.000
2014-07-22 14:17:56.000
โ07-26-2018 02:45 PM
Have you seen this topic: SnapLogic DateTime Conversion Guidelines
โ07-26-2018 02:57 PM
Yes I did. I tried to use every date conversion formula but its throwing the same error.
โ02-04-2019 03:10 PM
Did you ever figure this out? The date time formats for SQL server are not compatible from what I can find.
โ03-13-2023 03:14 PM
Any word on this? I know this is an old thread, but Iโm currently seeing the error, too.