(Solved) : Following Returns January 3rd 2007 Select One Following Cast 2007 Year 1 Month 3 Day B Ora Q32239077 . . .
Which of the following returns January 3rd, 2007?
Select one of the following?
A) CAST (2007 as a year, 1 as month, 3 as day)
B) In Oracle: TO_DATE(‘2007-1-3′,’YYYY-MM-DD’) In SQL Server:DATEFROMPARTS(2007,1,3)
C) In Oracle: ‘2007’ + ‘1’ + ‘3’ In SQL Server:DATEADD(yy,’2007′,mm,’1′,dd,’3′)
D) In Oracle: EXTRACT(YEAR FROM ‘2007-1-3′) + EXTRACT(MONTH FROM’2007-1-3’) + EXTRACT(DAY FROM ‘2007-1-3’) In SQL ServerYEAR(‘2007-1-3’) + MONTH(‘2007-1-3’) + DAY(‘2007-1-3’)
Expert Answer
Answer to Following Returns January 3rd 2007 Select One Following Cast 2007 Year 1 Month 3 Day B Ora Q32239077 . . .
OR