Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
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?
I, hope you
((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-01-01' AND '2016-05-31';
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 5/5/16, 4:18 AM|
|Seen: 428 times|
|Last updated: 5/5/16, 9:02 AM|