How to retrieve the user date format?

[peterraeves]

What's the function we can use to get the user's personal date format?

[Chuck Tomasi]

You could get it right from the sys_user table using the 'date_format' field.

[peterraeves]

That's what I do now, but this might cause me issues.

The user format is part of the session. So even if you change the format on the user table, as long as the session is not renewed, the user will still be working with his old format. This will give problems if you use the new format, with values in the old format. So i had hoped for something like gs.getUser().getDateFormat(). But it seems that does not exist?

[Gowrisankar Sat]

Hi Peter,

Checking this Out of curiosity, did you try the below method?

gs.getSession().getUser().getTimeFormat()

[peterraeves]

You probably mean

gs.getSession().getUser().getDateFormat()

But, yes! This is what I was looking for ^^. Thanks