In the PROMOTIONS table, the PROMO_BEGIN_DATE column is of data type DATE and the default date format is DD-MON-RR.
Which two statements are true about expressions using PROMO_BEGIN_DATE contained in a query? (Choose two.)
In the PROMOTIONS table, the PROMO_BEGIN_DATE column is of data type DATE and the default date format is DD-MON-RR.
Which two statements are true about expressions using PROMO_BEGIN_DATE contained in a query? (Choose two.)
PROMO_BEGIN_DATE is of type DATE, and in SQL, if a date is subtracted from another date, the result is the number of days between them. Therefore, PROMO_BEGIN_DATE – SYSDATE will return a number indicating the difference in days. Additionally, subtracting a number from a date in SQL will return a new date that is the specified number of days before the original date. Therefore, PROMO_BEGIN_DATE - 5 will return a date.
E is invalid BD is the correct answer
I think BD is correct!
BD tested
BD is correct
This query will return expected result.
PLEASE UPDATE THESE ANSWERS, IT IS RIDICULOUS HOW MANY ARE INCORRECT
BD CORRECT
BD correct tested with the HR schema
CD CORRECT
BD correct
BD are correct.