Hi All,
Greetings for the day!
I export my sales order details with create data and i found huge time different with export CSV file and live data.then i change the my Ubuntu server timezone as Asia/Colombo and also change the Postgresql database timezone as Asia/Colombo and run the test scenario. but i found same issue with export data set. then i check my database data table and i found the database stored values different than, live values and same as export data values. so anyone can help me to fix this issue.
Thanks you!
Are you sure the difference is something else than the conversion of timezones? Odoo stores datetimes by default in UTC +0 so if you're in a timezone +12 you will see a difference of twelve hours in your datetime.
Yenthe,
That's the issue i had. odoo by default save datetimes in UTC + 0. but my actual timezone is UTC + 05.30. then i'm going to export my data odoo unable to export my local timezone. but odoo convert that time to my local timezone in presentation layer. not in the data exporting process.