How to get the current date format for the repository..??

Hii guys,

i have a requirement where i need the current time or date format like (MMM dd yyyy OR MM/dd/yyyy HH:mm) which has been set

for the repository on content server. I have been through the dfc api , but still not able to find any methods providing relevant information regardig this.

Is there is any way through which we can get this information.

Thanks

Find more posts tagged with

BPM

Comments

msroth

Can't you just get it from Java?

import java.util.Date;
now = new Date();

KSMatson

You can also do this

select datetostring(DATE(NOW), 'mm/dd/yyyy hh:mi:ss') as formated_date from dm_server_config;

durgesh_sahu

Thanks Scott from replying, i have tried that but it dosen't work.

durgesh_sahu

Thanks Khurram for replying,

i tried the query you have given, but it returns the current date in the format we provide,not the pattern which is on the server. Actually i want to format the date i am getting through value assistance for the date type attribute,

thats why i want to know in which format the date value is coming through value assistance.

Is there a way we can do that.

Thanks

JorgKrause

Hi,

as far as I know, there is no date_format stored in the repository anywhere!

If you retrieve a date field without any pattern, it will automatically be formatted according to the local settings of your session, which indeed depend on settings on your PC.

You may add patterns while retrieving dates, either through Java or DQL. See IDfTime javadocs for further details on the available patterns.

Regards

Jørg