k
kumar san

Posted on 27th February 2024|2963 views

0
votes

Teradata Datediff

Explain about DatedDiff Function in Teradata

Answers
P
jordan chris

Posted on 27th February 2024

In SQL, we will use the DateDiff function to calculate the difference between two dates. But in Teradata, usage of “DataDiff” function can lead to error. So, instead of the DateDiff function, we will use ‘-’ operator to calculate the difference between two dates.

Example:

SELECT(DATE ‘2008-06-10’ - DATE ‘2008-05-28’ ) DAY;
 

Write your answer

STILL GOT QUERIES?

Get a Live FREE Demo
  • Explore the trending and niche courses and learning maps
  • Learn about tuition fee, payment plans, and scholarships
  • Get access to webinars and self-paced learning videos