Ashburn, VA(703) 728-6831
BitShop abides by: the Rotary International Four Way Test - Find out what that means..
To navigate our site click the menu at the top.
Written by:Steve Radich - Founder BitShop, Inc.10/5/2016 12:59 AM
If you are moving from Microsoft SQL Server to Snowflake you'll likely be moving some datediff sql statements over, datediff(m, date, date) gives the number of months between dates in Microsoft SQL Server - However in snowflake the syntax is different.
However something odd is the datediff will accept the datediff(m, date1, date2) syntax and instead of giving an error seems to give something along the lines of number of minutes between the dates (although it's not minutes).
If you are doing math based on this then this can lead to some numbers that look like they are completely wrong!
Make sure you read the datediff documentation on Snowflake's site:
0 comment(s) so far...
Find more about our founder