Applies To:
HP ALM, HP QC, Oracle Database
Issue:
Some date fields in an oracle database require the datatype to be converted.
Solution:
Use to_date to convert OR don't convert. Some of the tables seem temperamental.
SELECT *
FROM TEST
WHERE TEST.TS_CREATION_DATE > to_date('2010-03-01 10:32:00','yyyy-mm-dd hh24:mi:ss')
OR
Select *
From Test
Where Test.TS_CREATION_DATE > '2010-03-01 10:32:00'