View Only

 DATE Datatype Loading Issue from source to target

ali rana's profile image
ali rana posted 05-18-2023 22:01

we currently have a sybase db as source and ms sql server db as target. we have a table in source which has a column datatype of DATE sample value "2015-04-12". when we try to move this data using SPOON the value is inserted correctly in target db. however when we try to use a simple ktr integrated within spring boot and use kettle to initiate the same workflow the value that gets inserted in the target is -1 day, sample now would be "2015-04-11". we are not sure what is causing kettle to change this value. any insight and help regarding this issue is greatly appreciated.