Monday, March 12, 2012

Get the system date format?

Hi!
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..Maybee i should have written "get the date format from regional settings".

No comments:

Post a Comment