Wrong date format in database
Posted: Mon Apr 13, 2015 9:13 amHello,
We are facing one random issue on date columns. The date entry fields has dd/MM/yyyy as dispay format and ddMMyy as edit format. When we enter date e.g 010101
it shows correct value on screen i.e 01/01/2001 but in database it is being stored as 2001-01-01 BC. Not sure when and why the "BC" is getting appended to the date value. This is affecting all the filters, find search and compare operations.
- Can reproduce issue with other edit formats.
- All the dates which are affected are post 01/01/2000.
- "BC" is getting appended to both DATE and DATETIME columns.
- Servoy version 7.4.2.
Any solution will be appreciated. Thanks in advance.
Lopamudra
lopamudram@mindfiresolutions.com
We are facing one random issue on date columns. The date entry fields has dd/MM/yyyy as dispay format and ddMMyy as edit format. When we enter date e.g 010101
it shows correct value on screen i.e 01/01/2001 but in database it is being stored as 2001-01-01 BC. Not sure when and why the "BC" is getting appended to the date value. This is affecting all the filters, find search and compare operations.
- Can reproduce issue with other edit formats.
- All the dates which are affected are post 01/01/2000.
- "BC" is getting appended to both DATE and DATETIME columns.
- Servoy version 7.4.2.
Any solution will be appreciated. Thanks in advance.
Lopamudra
lopamudram@mindfiresolutions.com