logo-MindMajix
k
kumar san

Posted on 20th June 2024|3119 views

0
votes

Teradata Datediff

Explain about DatedDiff Function in Teradata

1 answers
Answers
P
jordan chris

Posted on 20th June 2024| views

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
Name
Course *
Email *
Phone Number