HOW TO CHANGE DATE FORMAT FROM THE DATABASE

Question

Hi,
Please I have date fields on my odoo application and I have changed the date format to dd-mm-yyyy  from the Settings>Language menu. However, when I export my data to excel, the date is not fromatted the same way. I have a feeling that this has to be done from postgres. Can someone please help?

Gustavo Hinojosa · Answer

I, hope you
SELECT ((po.date_order AT TIME ZONE 'UTC' AT TIME ZONE 'BOT')::date) as date
,((po.create_date AT TIME ZONE 'UTC' AT TIME ZONE 'BOT')::timestamp) as datetime
,to_char(((po.date_order AT TIME ZONE 'UTC' AT TIME ZONE 'BOT')::date), 'DD/MM/YYYY') as date_format
,to_char(((po.create_date AT TIME ZONE 'UTC' AT TIME ZONE 'BOT')::timestamp), 'DD/MM/YYYY HH:MM:SS') as datetime_format
FROM purchase_order AS po
WHERE ((po.date_order AT TIME ZONE 'UTC' AT TIME ZONE 'BOT')::date) BETWEEN '2015-0

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
How to get Creation Date for created Customer? Ratkaistu date	1 tammik. 25	17051
How to calculate total days between count_start and count_end? Ratkaistu date	1 tammik. 20	3293
How to give the specific date like "2022-12-31",not the default date as today? Ratkaistu date	1 jouluk. 19	5420
How to compare with the date that which one is earlier,which one is late? Ratkaistu date	1 jouluk. 19	16473
any body know how to convert date widget to hijri date widget? date	3 huhtik. 18	4580

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!