Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Boekhouding
Voorraad
PoS
Project
MRP

All apps

Alle posts Personen Badges

Labels (Bekijk alle)

odoo accounting v14 pos v15

Over dit forum

Help

compute datetime field from date - how to deal with timezones

date timezone datetime

3 Antwoorden

22502 Weergaven

Hugo M.

Hello,

I have a model with a date field to be an user input, and a computed datetime field. Something like this:

class MyModel(models.Model):
    _name = "my.model"

    my_date = fields.Datetime(string='My date')
    my_datetime = fields.Datetime(string='My datetime', compute='_get_datetime_from_date')

My problem is that the computed datetime is stored according my timezone, for example if I'm on UTC-3 and I enter 01/01/2018 in my_date, my_datetime is computed as 31/12/2017 21:00:00. This is a problem for any datetime behind UTC as it's effectively stored as the day before. I need it to be stored as 01/01/2018 0:00:00. How can I solve this issue?

Thanks a lot.

Ray Carnes

Can you post the code of _get_datetime_from_date?

Manish Bohra

Can you post your compute method code ??

Sushma

Beste antwoord

Hi Hugo,

I was having this same issue, so solved like passing Timezone and converting into UTC to save in database, like following:

def convert_TZ_UTC(self, TZ_datetime):
    fmt = "%Y-%m-%d %H:%M:%S"
    # Current time in UTC
    now_utc = datetime.now(timezone('UTC'))
    # Convert to current user time zone
    now_timezone = now_utc.astimezone(timezone(self.env.user.tz))
    UTC_OFFSET_TIMEDELTA = datetime.strptime(now_utc.strftime(fmt), fmt) - datetime.strptime(now_timezone.strftime(fmt), fmt)
    local_datetime = datetime.strptime(TZ_datetime, fmt)
    result_utc_datetime = local_datetime + UTC_OFFSET_TIMEDELTA
    return result_utc_datetime.strftime(fmt)

Hugo M.

Auteur

Thanks! It worked perfectly.

Sushma

Glad to know :)

Jithin PP

where is 'TZ_datetime' using

Sushma

TZ_datetime is variable of datetime type that would be converted to UTC format

Aadeel S. Puri

Can you please help, how to use this function in my custom module field datetime. i want to show datetime in utc to all users.

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!

Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!

Aanmelden

Gerelateerde posts	Antwoorden	Weergaven
Take Users Timezone Opgelost timezone datetime	3 jul. 25	5283
Need Studio compute code to show number of days from today vs. a date field Opgelost date datetime	2 jan. 24	3456
Adding days to a date date datetime	2 jun. 22	5481
Time & Date Issue Opgelost timezone datetime	6 sep. 19	12517
How can I use date format only without time? Opgelost date datetime	2 jun. 18	6898

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!