Web Development

General discussion


Date Format

By adr1817 ·
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!

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by Wayne M. In reply to Date Format

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.

Collapse -

by adr1817 In reply to

i created a script instead .. thanks anyway

Collapse -

by LukCAD In reply to Date Format

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.

Collapse -

by adr1817 In reply to

Poster rated this answer.

Collapse -

by adr1817 In reply to Date Format

This question was closed by the author

Related Discussions

Related Forums