On Thu, Sep 16, 2010 at 1:55 AM, Ivan Prenosil <Ivan.Prenosil@...>wrote:

>
>
> > 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'
> ?
>
> I did try '15.09.2010, 20:40:06.6740' , '15.9.2010, 20:40:06.674',

'15.9.2010, 20:40:06.6740'. Thanks a lot.

>
>

--
Regards,
Lt Col (Retd) Rajiv Dular Singh Chauhan
09601704890
0265-2637655
_____________________________


[Non-text portions of this message have been removed]