Skip to Content
Menu
This question has been flagged
1 Reply
6004 Views

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

Avatar
Discard

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

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

Best Answer
  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

Avatar
Discard
Related Posts Replies Views Activity
1
Nov 22
5564
1
Oct 21
3241
2
Nov 18
10159
1
Mar 15
3569
4
Mar 15
5203