Database Tutorial

Course Tutorial Site

Site Admin

SQL Date Math

without comments

This page examine how SQL math works in Oracle, MySQL, and SQL Server databases. Each implements ANSI functions differently but it’s unfair to say which is in full compliance or not with the ANSI specifications. It is probably fair to say they’re all close if not in compliance, and leave the rest to their respective marketing departments.

SQL implementations differ on how you may use dates to perform basic math operations as dates. Some provide an intuitive and simple approach while others deliver the utility through the exclusivity of SQL functions.

Written by michaelmclaughlin

October 23rd, 2009 at 9:33 am

Posted in

Leave a Reply