Web Development

Ask something
Discussion Locked

Date Format

0 helpful
5 replies

by adr1817

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a program running at the moment but the date format keep on changing every time I update my database. Date format is on UK format dd/mm/yy but when I update or save it, turns to US format mm/dd/yy. Please help!

5 replies

by wayne m.

This sounds like a default date setting somewhere in your system. More information is required to isolate it, but I would start by looking at the machine used to display the date. On Windows-based systems, look at Settings-Control Panel-Regional Settings. There will be a tab to set the date display options. You may also check database settings. I believe Oracle has a display setting for PL/SQL to set the date mode, but I don't recall that off the top of my head - check the Oracle web site. If you are using a specific application and changing the system settings doesn't help, you may need to try the application help system or telephone support. Some applications have hard-coded date displays, so you may be out of luck in that case.

by lukcad

It is usually bug of encoding and decoding of datetime in programm by programmer who wrote this application. Better way will if you read the "about programm" and make the phone call to firm by their contact phone of service department.

This discussion is closed to new replies.