Understanding Date Arithmetic in SQL without Resulting in TIMESTAMP

Calculating Statistics Over Partitions with Window Functions in Hive

Querying Timestamps in SQL Server: Techniques for Retrieving Values Before and After a Specific Date