Hello Pavel and Dimitry

> What is the data type of RCPTDATE (and what is the DB SQL dialect)?
> For TIMESTAMP data type, '06/30/2006' would be cast to '06/30/2006
> 00:00:00', i.e. the beginning of the day.
>

My apologies for a silly question - I relized (when I woke up this
morning) that the field I was dealing with was a TimeStamp. Problem
solved and thanks for your replies.

regards

Bill