Hi Expert ,
i have a transaction table which one column called " MIDTRANSSTARTTIME datatype is timestamp " i want transaction record between 01-12-17 04:44:25.696000000' - '01-12-17 04:44:34.966000000' which is around 9 min in my case .
I'm using below query but unable to get the proper record please help .
SQL> select MIDTRANSAUDITID, TOKENID from TBLTMIDTRANSAUDIT WHERE
MIDTRANSSTARTTIME BETWEEN ('01-12-17 04:44:25.696000000') and ('01-12-17 04:44:34.966000000');
Your suggestion will be acceptable.