Tag archives for date

Documentum : BUG in DQL Date Functions When Together Use Of DATEFLOOR, DATEDIFF, DATETOSTRING and DATEADD
Hello, Just a post concerning the BUG of use of DATEFLOOR, DATEDIFF, DATETOSTRING and DATEADD together. To illustrate this problem, for example, we would like to list the documents (r_object_id) modified during the last year: ==> Error occured during query execution :error: "A Parser Error (syntax error) has occurred in the vicinity of: SELECT r_object_id FROM dm_document WHERE r_modify_date >= "   ==> Error occured ...more»
Documentum : Locale, Date Storage, Update of Last Modification Date / Last Modifier (r_normal_tz, r_tz_aware, r_modify_date)
Hi, Just a post concerning the locale, date storing and updating of r_modify_date/r_modifier fields in Documentum, indeed, these fields are overridden automatically during the document's saving. Thus, it's necessary to store and set the previous values of these fields. Locale / Date Storage : The dm_docbase_config.r_normal_tz property of docbase explains how Content Server stores dates in the repository. Its value is ...more»
Copyright ® 2012 Huseyin Ozveren. No reproduction, even partial, can be used from this site and all its contents including text, documents, images, etc.. without the express permission of the author.