Documentum DQL: How can I get UTC time zone for Date columns to parse to .NET?

datetime timezone string-parsing documentum documentum-dfc
Scott Baker picture Scott Baker · Nov 23, 2011 · Viewed 9.1k times · Source

Documentum (DQL via DFC) always returns Date result columns as a string formatted like this: 

Wed Oct 19 16:01:59 PDT 2011

...and the .NET DateTime.Parse function chokes on this — especially the PDT time zone (TZ henceforth) part of the strings — as far as I can tell, there is no concept of these TZ abbreviations in the DateTime parsing. Sure, it'll understand +8:00 but not PDT.

The TZ is based on the TZ of the content server, which may not always be the same TZ as the consumer of the web service (we're feeding out the DQL results via web service).

SO... if I can get Documentum to ALWAYS give me the UTC time in those strings, I can do the conversion quite easily on the client and always have their correct time zone.

Can this be done? Is there a Documentum setting for the content server to always return GMT times?

Alternative solutions?

Answer

lastnitescurry picture lastnitescurry · Nov 29, 2011

For date format see dfc.date_format = setting which you can define in your dfc.properties file.

An excerpt from dfcfull.properties for details:

date format can be specied using the syntax of the Java SimpleDateFormat class

What version of Content Server do you have? In D6.x dates are stored in UTC and transformed to local TZ of client by Documentum client apps. For more details see: https://community.emc.com/message/545879#545879

Related questions

Convert UTC date time to local date time

From the server I get a datetime variable in this format: 6/29/2011 4:52:48 PM and it is in UTC time. I want to convert it to the current user’s browser time using JavaScript. How this can be done using JavaScript or …

Read More
Daylight saving time and time zone best practices

I am hoping to make this question and the answers to it the definitive guide to dealing with daylight saving time, in particular for dealing with the actual change overs. If you have anything to add, please do Many systems …

Read More
How to make an unaware datetime timezone aware in python

What I need to do I have a timezone-unaware datetime object, to which I need to add a time zone in order to be able to compare it with other timezone-aware datetime objects. I do not want to convert my …

Read More