Oracle OCP 082知识
剩余时间:
第 40 题 (多选题):
You need to calculate the number of days from 1st January 2019 until toda. Dates are stored in the default format of DD-MON-RR.Which two queries give the required output.
A. SELECT ROUND(SYSDATE-TO_DATE('01/JANUARY/2019'))FROM DUAL .
B. SELECT SYSDATE-TO_DATE('01-JANUARY-2019') FROM DUAL; .
C. SELECT ROUND(SYSDATE-'01-JAN-2019') FROM DUAL;.
D. SELECT TO_DATE(SYSDATE, DD/MONTH/YYYY")-'01/JANUARY/2019' FROM DUALI
E. SELECT TO_CHAR(SYSDATE, DD-MON-YYYY)-'01-JAN-2019' FROM DUAL;
显示答案
正确答案:
A,B
解析:
上一题
下一题
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80