Question: DateValue is a date column that contains the posting date of transaction. A query should label each transaction based on how many days have elapsed

DateValue is a date column that contains the posting date of transaction. A query should label each transaction based on how many days have elapsed since the transaction was posted. The requested ranges are
0
-
30
days,
31
-
60
days, and greater than
90
days. How does the following CASE state fail to label the transcations appropriately? CASE WHEN DATEDIFF(d, DateValue, CURRENT_TIMESTAMP)<=90 THEN '61-90 days'

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!