As someone who has taught over 1,000 database architecture and SQL classes on all systems and written over 90 books, I can tell you that the date and timestamp syntax differences across databases will bite you.

I have written multiple blog posts to ensure you have a clear picture of the dates and timestamp functions across all databases. Below are the links to posts on my website for each system.

Best Regards,

Tom Coffing
CEO, Coffing Data Warehousing
Phone: 513 300-0341
YouTube Video:–I7bCDKQ