> 2. For an existing record in table a PATIENTCHARGESDUES, the under mentioned select statement does not returns the exisiting
> record when i uncomment the line that compares field ENTRYTIME even on copy paste the field value. Rest all fields work fine.
> I've tried removing zeros event ie '15.9.2010, 20:40:06.674'
>
> select * from PATIENTCHARGESDUES p where
> p.SERVICEID='2300094' and
> p.AMOUNT=2000 and
> p.AMOUNT_BEFORE_DISCOUNT = 2000 and
> p.HOSPSRVCDESC='OUT PATIENT' and
> p.REMARKS='1x1800. ' and
> p.DATEOFEXPENSE = '15.9.2010, 20:20:14.8230' and
> p.ENTEREDBY = 'HISADMIN' and
> p.ENTRYPC = 'NannuPC'
> /*and
> p.ENTRYTIME='15.09.2010, 20:40:06.674'
> p.REGDID=:REGDID and
> p.RECEIPTANTID=:RECEIPTANTID;*/

Are you sure the .674 is correct ? Timestamp's precision is 4 decimal places after seconds.
Can you try
p.ENTRYTIME BETWEEN '15.9.2010, 20:40:06.6740' AND '15.9.2010, 20:40:06.6749'
?