AnsweredAssumed Answered

Date issue on AIX

Question asked by chris_8226 on Jul 17, 2012
Latest reply on Jul 19, 2012 by 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

Outcomes