Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0002073 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 01. General setup | minor | always | 2007-10-11 02:45 | 2008-06-12 09:43 | |||
Reporter | user71 | View Status | public | |||||
Assigned To | cromero | |||||||
Priority | normal | Resolution | fixed | Fixed in Version | 2.35 | |||
Status | closed | Fix in branch | Fixed in SCM revision | |||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Merge Request Status | ||||||||
Review Assigned To | ||||||||
OBNetwork customer | No | |||||||
Web browser | ||||||||
Modules | Core | |||||||
Support ticket | ||||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0002073: Time in background scheduler | |||||||
Description | When you create a new entry in process scheduler window the time that is stored, is always 00:00:00. I think it happens in all time fields in the application. I try in an installation based in oracle and it works fine. Openbravo 2.34 Tomcat 5.5 Postgre 8.2.4 Jdk 1.5.0_12 Ant 1.7.0 Gentoo | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
![]() |
|
![]() |
|
(0002340) user71 2007-10-11 09:13 edited on: 2008-06-12 09:22 |
Logged In: YES user_id=1737231 Originator: NO I just found this bug too Environment OS: Linux - Centos 4 (test/prod) & Windows XP (dev) DB: Postgres 8.1.9 (test/prod) & 8.2.4 (dev) Release: 2.34 Browser: Firefox 2.0.0.6, IE 7 The problem is that the generated xsqlc converts the time string using TO_DATE function. In Postgres at least that will just give a date. It needs to use TO_TIMESTAMP to get a time data type. |
(0002341) cromero (viewer) 2007-10-16 16:30 edited on: 2008-06-12 09:22 |
Logged In: YES user_id=1500614 Originator: NO This bug has been fixed. We have modified Wad.java in order to transform to_date to to_timestamp for ALL time fields. It will be included into next release. Carlos Romero Openbravo Team |
(0005662) user71 2005-06-01 00:00 edited on: 2008-06-12 09:43 |
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis. You can see the original bug report in: https://sourceforge.net/support/tracker.php?aid=1811231 [^] |
Copyright © 2000 - 2009 MantisBT Group |