I am having an issue when importing data from a SQL table using the Query Databa

hayleyw over 12 years ago

I am having an issue when importing data from a SQL table using the Query Database node that executes a SQL SELECT statement then transferring it to a mySQL table in appian using a Write to Datastore node and any dates that are imported and inserted into the table are consistantly 2 days earlier. Has anyone else come across this or know of any solutions?

Many thanks...

Discussion posts and replies are publicly visible

Parents

0 Christine
Appian Employee
over 12 years ago

This generally means that the db server and Appian are using diff time zone settings. Try converting the date to the correct time zone before write. Hope that helps
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Christine
Appian Employee
over 12 years ago

This generally means that the db server and Appian are using diff time zone settings. Try converting the date to the correct time zone before write. Hope that helps
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data