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.
Tom Coffing, better known as Tera-Tom, founded Coffing Data Warehousing, where he has been CEO for the past 30 years. Tom has written over 90 books on Architecture, performance tuning, and SQL on all relevant systems. Tom has taught over 1,000 classes worldwide, and he is the designer of the Nexus, which celebrates 20 years of brilliantly integrating all databases.