I am attempting to do a select statement to identify filespaces that hove
not been backed up.

I am getting strange results so I isolated the problem to the field
current_timestamp.

When I run the following:

select current_timestamp as Stamp , date(current_timestamp) as Date from
libraries     <<<<<===== Can be any table but smaller the better I only have
2 libraries.

I am running it today 4-21-2000 and it returns 5-21-2000 even though the
server date is accurate along with actlog.

Does anybody know of a patch to cause/correct? I did apply iy05372 a couple
of days ago.

Bill Slaughter
Tupperware U.S., Inc.
14901 S. Orange Blossom Trail
Orlando, FL 32837
(407) 826-4580
(407) 826-8890 Fax
Text Pages 4079747099.5701585 AT pagenet DOT net