How to add +5:30 hours to existing date format

[Anonymous]

Hi Team, 

Actually in our DB date format in UTC and we would like to add that to +5:30 hours to that date column (IST);

Can you please help me how to add +5:30 hours to date column

Regards

Jay

[manodwhb]

@Jayrapolu,convert UTC to IST and then add the hours using TalendDate.addDate() function. you can also check the below link with different way.

https://stackoverflow.com/questions/35653484/how-can-i-convert-local-time-to-utc-and-vice-versa-in-a...