COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
standard date format of oracle sql
|
|
YY-MON-DD
|
|
|
DD-MON-YY
|
|
|
DD-MM-YYYY
|
|
|
DD/MM/YYYY
|
Explanation:
Detailed explanation-1: -The default display and input format for any date is DD-MON-YY. Valid Oracle dates are behween Januar 1, 4712 B C., and December 31, 9994 A.D. SYSDATE is a date function that returns the current date and time. You can use SYSDATE just as you would use any other column name.
Detailed explanation-2: -In Oracle databases, the date is in the format DD-MMM-YY (eg: 21-May-22), while Qlik Replicate from Oracle to Kafka, the default format in Kafka is 2022-05-21 00:00:00 (even source & destination representing the same date but their format differs). In SQLite Data Function there are some types include: YYYY-MM-DD.
There is 1 question to complete.