You have been tasked to create a table for a banking application.One of the columns must meet three requirements:1. Be s
Posted: Sun Jun 11, 2023 3:55 pm
You have been tasked to create a table for a banking application.One of the columns must meet three requirements:1. Be stored in a format supporting date arithmetic without using conversion functions2. Store a loan period of up to 10 years3. Be used for calculating interest for the number of days the loan remains unpaidWhich data type should you use?
A. INTERVAL YEAR TO MONTH
B. INTERVAL DAY TO SECOND
C. TIMESTAMP WITH LOCAL TIMEZONE
D. TIMESTAMP E. TIMESTAMP WITH TIMEZONE
A. INTERVAL YEAR TO MONTH
B. INTERVAL DAY TO SECOND
C. TIMESTAMP WITH LOCAL TIMEZONE
D. TIMESTAMP E. TIMESTAMP WITH TIMEZONE