General discussion

  • Creator
    Topic
  • #2189246

    Date Format

    Locked

    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!

All Comments

  • Author
    Replies
    • #3060176

      Reply To: Date Format

      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.

      • #3045255

        Reply To: Date Format

        by adr1817 ·

        In reply to Reply To: Date Format

        i created a script instead .. thanks anyway

    • #3053356

      Reply To: Date Format

      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.

    • #3045254

      Reply To: Date Format

      by adr1817 ·

      In reply to Date Format

      This question was closed by the author

Viewing 2 reply threads