Home Forums SQL Server 7,2000 T-SQL equivalent of DateSerial() in T-SQL? (SQL2000) RE: equivalent of DateSerial() in T-SQL? (SQL2000)

  • 3ms is the smallest unit of time a datetime field can capture. So by subtracting 3ms from midnight, you get the latest possible time that could be captured on the earlier day, which will catch all time values for the previous day, not just those at midnight of the prior day.