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

EMail Us
 

 
Our Blogs
 
Loading BitShop News...
   
 
Morals
 

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

   
 
NEXT STEP
 

To navigate our site click the menu at the top.

   
 
Non-BitShop Ads (Hold Control when you click)
 
Oct5

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:

 

References:

  • Proper Usage: https://docs.snowflake.net/manuals/sql-reference/functions/datediff.html

Tags:

Your name:
Your email:
(Optional) Email used only to show Gravatar.
Your website:
Title:
Comment:
Security Code
CAPTCHA image
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
Operational


   
 
Learn More!
 

Find more about our founder

Steve Radich:

LinkedIn Profile

Contact Us