BitShop LLC
Ashburn, VA
(703) 728-6831
(703) 563-3826

EMail Us

Our Blogs
Loading BitShop News...

BitShop abides by: the Rotary International Four Way Test - Find out what that means..


To navigate our site click the menu at the top.

Non-BitShop Ads (Hold Control when you click)

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:



  • Proper Usage:


Your name:
Your email:
(Optional) Email used only to show Gravatar.
Your website:
Security Code
Enter the code shown above in the box below
Add Comment  Cancel 
Please Share Your Comments With Us

Submit Comment
Excellent Info0.00%0
Great Info0.00%0
Useful Info0.00%0
Not so useful0.00%0
Confusing / Useless0.00%0

Number of Comments0,Average of Ratings
No comment.
Network Status

ALL Servers

Learn More!

Find more about our founder

Steve Radich:

LinkedIn Profile

Contact Us