Which three expressions using the new date and time data types are valid?

Examine the list of variables and their data types:
Name Data Type
TS, TS1 TIMESTAMP
TSZ TIMESTAMP WITH TIME ZONE
TLZ TIMESTAMP WITH LOCAL TIME ZONE
IYM INTERVAL YEAR TO MONTH
IDS, IDS1 INTERVAL DAY TO SECOND
Which three expressions using the new date and time data types are valid?

Examine the list of variables and their data types:

Name Data Type
TS, TS1 TIMESTAMP
TSZ TIMESTAMP WITH TIME ZONE
TLZ TIMESTAMP WITH LOCAL TIME ZONE
IYM INTERVAL YEAR TO MONTH
IDS, IDS1 INTERVAL DAY TO SECOND

Which three expressions using the new date and time data types are valid?

A.
IDS*2

B.
TS + IYM

C.
TS – TS1

D.
IDS -TS

E.
IDS +IYM



Leave a Reply 0

Your email address will not be published. Required fields are marked *