I am extracting a field of data type datetime from a SQL database but when it is displayed, it shows the date is 8 hours behind the actual date and time.
For other fields which are defined as date, the dates are displayed correctly.
What could be the possible reason for this and how can I fix it?