Date issue on AIX

[chris_8226]

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/phpbbforum/viewtopic.php?f=2&t=102 ) did not solve the issue.

Can you please advise? Here is our configuration from owplugins.xml:

<!– Date format string to use for time only values . e.g.: (HH:mm) –>
<TimeFormatString type="com.wewebu.ow.server.settingsimpl.OwSettingsPropertyLanguageString" scope="site"
edit="true" list="true" displayname="Date format" helppath="owsettings/DateFormatString.jsp">
<property lang="de">dd.MM.yyyy HH:mm:ss</property>
<property lang="en">yyyy-mm-dd hh:mm:ss</property>
</TimeFormatString>

Also tried with:

<!– Date format string to use for time only values . e.g.: (HH:mm) –>
<TimeFormatString type="com.wewebu.ow.server.settingsimpl.OwSettingsPropertyLanguageString" scope="site"
edit="true" list="true" displayname="Date format" helppath="owsettings/DateFormatString.jsp">
<property lang="de">dd.MM.yyyy HH:mm:ss</property>
<property lang="en"> yyyy-MM-dd-HH.mm.ss.SSSSSS</property>
</TimeFormatString>

Our environment:

AIX operating system
Content Manager + 8.4.03.100
jdbc version: bash-3.2# /usr/java6/bin/java -jar ojdbc6.jar
Oracle 11.2.0.2.0 JDBC 4.0


Thanks
Chris

[vahe]

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>

[chris_8226]

Thank you so much…this resolved the issue 🙂