« Return to Thread: [Bug 660] New: oracle TIMESTAMP types not handled well

[Bug 660] New: oracle TIMESTAMP types not handled well

by Bugzilla from bugzilla-daemon@helma.at :: Rate this Message:

Reply to Author | View in Thread

http://dev.helma.org/bugs/show_bug.cgi?id=660

           Summary: oracle TIMESTAMP types not handled well
           Product: Helma
           Version: CVS trunk
          Platform: Other
        OS/Version: Linux
            Status: NEW
          Severity: enhancement
          Priority: P5
         Component: Database Layer
        AssignedTo: helma-dev@...
        ReportedBy: nostalgiker@...


accessing a DATE column gives me a JS Date object.

but accessing a column with type TIMESTAMP WITH TIME ZONE or TIMESTAMP WITH
LOCAL TIME ZONE [1] returns a string. this should also return a Date object.

TIMESTAMP type is interesting because it can handle TZ - which is hard with
DATE alone, where i have to worry about TZ conversion instead of jdbc&oracle
doing The Right Thing.

tried with oracle 10g, helma1 trunk

[1]
http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/datatype.htm#CNCPT413

--
Configure bugmail: http://dev.helma.org/bugs/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Helma-dev mailing list
Helma-dev@...
http://helma.org/mailman/listinfo/helma-dev

 « Return to Thread: [Bug 660] New: oracle TIMESTAMP types not handled well