Odoo Help

0

how can i get the date in dd mm yyyy format please help me?

sql
By
Derenik
on 2/5/14, 8:13 AM 843 views

how can i get the date in dd mm yyyy format please help me

You want to get the date in dd mm yyyy format using SQL query ?

Hiral Patel (hip)
on 2/5/14, 9:26 AM

SQL Query : select to_char(date,'DD/MM/YYYY') from table_name;

Hiral Patel (hip)
on 2/6/14, 7:45 AM
0

Prakash

--Prakash--
Prakash
3173
| 5 4 7
Bikaner, India
--Prakash--

OpenERP Devloper at SunARC Technology

Prakash
On 2/5/14, 8:21 AM
  1. OpenERP Menu: Settings --> Translations --> Languages

  2. Open your Language and edit the record to change the Date Format to %d/%m/%Y

image description

Your Answer

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

Question tools

0 follower(s)

Stats

Asked: 2/5/14, 8:13 AM
Seen: 843 times
Last updated: 3/16/15, 8:10 AM