Jonathan

I changed the query and the results now match. Your comment regarding the last day of the month triggered a recollection about something similar I saw recently in SQL Server...

Thanks Jonathan and SQLBill! Great input and you've all helped a great deal. The data is stored as the INT data type. We didn't consider that UNIX time would be...

Having recently learned SQL Server one of the first things my instructor impressed upon us was to begin each SQL session in Query Analyzer with the statement:

USE [databasename]

GO

This will save...