This question has been flagged
3 Replies
7128 Views

i have a website field called "appointment_date"

selected appointment date is not coming in odoo backend record.please help me some body. i want to show the exact date of that field

Avatar
Discard
Best Answer

Odoo stores date and time in UTC, not the Local Timezone.

There is a difference of 5 Hours and 30 Minutes between IST And UTC

It may be 5:30 AM in India, but in the database its stores 12:00 AM 

To Change Time Zone 

  • Activate Developer Mode 

  • Go to Settings> Users & Companies> Users 

  • Preferences> Timezone

Avatar
Discard
Author

i have done this i set the user time zone as asia/kolkata still time is not changed.

Best Answer

You can add timedelta 5:30 

(x.custom_datetime + timedelta(hours=5,minutes=30)).strftime('%d %B %Y %I:%M %p')

Avatar
Discard
Best Answer

Hi,

Please check this,

https://www.odoo.com/fr_FR/forum/aide-1/question/time-zone-problem-in-odoo-118905

https://www.odoo.com/fr_FR/forum/aide-1/question/how-to-convert-utc-datetime-to-local-118994

Muhammed Ali M - iWesabe

Avatar
Discard