Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003

    Unanswered: Get the system date format?

    I'm trying to get hold of the systems date format in my code so that I can change a date I've got. Dates are stored with default format in the database. I'm presenting a date in a messagebox (where it becomes text) and I want to change the format to the system format before I put it in the text. The date must be right with different kind of system settings, swedish, uk...

    Can I do that?

    I'm using:
    to_char(date, 'DD/MM/YYYY')
    This works, but of course the format will be uk all the time.

    I dont want to write the format, because then i does not mater what my system settings are.

    Hope i made my self understandable..

  2. #2
    Join Date
    Sep 2003
    Maybee i should have written "get the date format from regional settings".

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts