Date issue on AIX

chris_8226 — Tue, 17 Jul 2012 08:23:18 GMT

Hi,Our date search from a search template is not working. When using the date widget, the format of the date to be searched is "yyyy-MM-dd HH:mm:ss.S". The format required by Content Manager seems to be "yyyy-mm-dd-HH.mm.ss.SSSSSS". The similar thread in the forum (http://www.openworkdesk.org/phpbbf

Re: Date issue on AIX

vahe — Tue, 17 Jul 2012 08:46:09 GMT

The problem is the different format of TimeStamps (java.sql.Timestamp) that is used to perform searches againt IBM CM (XPpath/XQPE query):

odbcTimestampFormat
yyyy-mm-dd hh:mm:ss[.f…] - e.g. 2012-07-10 22:00:00 or 2012-07-10 22:00:00.0
Timestamp ISO Format
yyyy-MM-dd-HH.mm.ss.SSSSSS - e.g. 2012-10-08-12.13.52.412000

Till now, we didn’t have any problem with the odbcTimestampFormat on Windows machine, but for AIX environments we have to extend our application.

Since version OWD 3.2.0.1/4.0.0.0 Final OWD the used Timestamp format is configurable in the owbootstrap.xml.

<TimestampFormat>yyyy-MM-dd-HH.mm.ss.SSSSSS</TimestampFormat>‍

With this entry you can override the default format – and define an own (e.g. ISO TIMESTAMP format) – this has nothing to do with the <DateFormatString> (frontend display format) from the owplugins.xml, here you can leave like this: <property lang="en">yyyy-mm-dd hh:mm:ss</property>

Re: Date issue on AIX

chris_8226 — Thu, 19 Jul 2012 06:51:52 GMT

Thank you so much…this resolved the issue 🙂

topic Re: Date issue on AIX in Alfresco Archive

Date issue on AIX

Re: Date issue on AIX

Re: Date issue on AIX