Oracle Timestamps

Suite and Optimus Suite 5
#1

Everything seems to be updated fine except when i try to update a row from the database that has a timestamp in one of the columns. As seen below, the log sees everything as ok but oracle sees TESTING3=‘6/5/2009 10:00:00’ as an invalid date. In oracle the timestamp reads: 6/5/2009 10:00:00 AM. i believe the WHERE portion of the sql statement is passing and looking for a string date rather than an actual timestamp. Therefore, no row is seen or updated. Is there any workaround to this particular issue??

DB query
UPDATE TESTING SET JOB_ID=‘QA’,JOB_STRING=‘Reliability & Quality Assurance’,TESTING=‘1.2’,TESTING2=‘10’,TESTING3=‘6/5/2009 10:00:00’ WHERE TESTING_ID=‘17’

Done in : 9ms

#2

Sorry the time is 6/5/2011 12:51:35 AM in the DB and reads out to 6/5/2011 00:51:35 to the page.

#3

I’m imagining ill have to format the date before it reads in and after it reads out. I’m just not sure where to do that within the script

#4

If you are using connector - there is a beforeProcessing server side events, from which you can access all the data and make necessary manipulations before saving

docs.dhtmlx.com/doku.php?id=dhtm … _updates&s[]=complex&s[]=updates

#5

HeyStanislav,

When a date is pulled from an oracle database the format is changed from 8/6/2011 5:58:55 PM to 8-6-2011 17:58:55 but in the grid it gets changed to 8/6/2011 17:58:55.

What class within the package actually formats the date before it is sent to the grid ?

#6

NM , figured out what i was trying to accomplish