Answered step by step
Verified Expert Solution
Question
1 Approved Answer
7 CONTACT DATE is a datetime column. Which of the following will return thirty days before CONTACT DATE? T ONE OF THE FOLLOWING (1 PT)
7 CONTACT DATE is a datetime column. Which of the following will return thirty days before CONTACT DATE? T ONE OF THE FOLLOWING (1 PT) A. In Oracle: ADD DAYS (CONTACT DATE, -30) In SQL Server: DAY(-30, CONTACT DATE) B. In Oracle: ADD_DAYS(CONTACT DATE, 30) In SQL Server: DAY(30, CONTACT DATE) C. In Oracle: CONTACT DATE 30 In SQL Server: DATEADD(d, -30, CONTACT DATE) D. In Oracle: CONTACT_DATE + 30 In sQL Server: DATEADD(d, 30, CONTACT DATE)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started