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
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
|
select date_part(millennium, foo) from tbl1;
select date_part(millennia, foo) from tbl1;
select date_part(mil, foo) from tbl1;
select date_part(mils, foo) from tbl1;
select date_part(century, foo) from tbl1;
select date_part(centuries, foo) from tbl1;
select date_part(c, foo) from tbl1;
select date_part(cent, foo) from tbl1;
select date_part(cents, foo) from tbl1;
select date_part(decade, foo) from tbl1;
select date_part(decades, foo) from tbl1;
select date_part(dec, foo) from tbl1;
select date_part(decs, foo) from tbl1;
select extract(epoch from foo) from tbl1;
select extract(year from foo) from tbl1;
select extract(years from foo) from tbl1;
select extract(y from foo) from tbl1;
select extract(yr from foo) from tbl1;
select extract(yrs from foo) from tbl1;
select extract(quarter from foo) from tbl1;
select extract(quarters from foo) from tbl1;
select extract(qtr from foo) from tbl1;
select extract(qtrs from foo) from tbl1;
select extract(month from foo) from tbl1;
select extract(months from foo) from tbl1;
select extract(mon from foo) from tbl1;
select extract(mons from foo) from tbl1;
select extract(week from foo) from tbl1;
select extract(weeks from foo) from tbl1;
select extract(w from foo) from tbl1;
select extract(dayofweek from foo) from tbl1;
select extract(dow from foo) from tbl1;
select extract(dw from foo) from tbl1;
select extract(weekday from foo) from tbl1;
select extract(dayofyear from foo) from tbl1;
select extract(doy from foo) from tbl1;
select extract(dy from foo) from tbl1;
select extract(yearday from foo) from tbl1;
select extract(day from foo) from tbl1;
select extract(days from foo) from tbl1;
select extract(d from foo) from tbl1;
select extract(hour from foo) from tbl1;
select extract(hours from foo) from tbl1;
select extract(h from foo) from tbl1;
select extract(hr from foo) from tbl1;
select extract(hrs from foo) from tbl1;
select extract(minute from foo) from tbl1;
select extract(minutes from foo) from tbl1;
select extract(m from foo) from tbl1;
select extract(min from foo) from tbl1;
select extract(mins from foo) from tbl1;
select extract(second from foo) from tbl1;
select extract(seconds from foo) from tbl1;
select dateadd(s, 123, foo) from tbl1;
select dateadd(sec, 123, foo) from tbl1;
select dateadd(secs, 123, foo) from tbl1;
select dateadd(millisecond, 123, foo) from tbl1;
select dateadd(milliseconds, 123, foo) from tbl1;
select dateadd(ms, 123, foo) from tbl1;
select dateadd(msec, 123, foo) from tbl1;
select dateadd(msecs, 123, foo) from tbl1;
select dateadd(msecond, 123, foo) from tbl1;
select dateadd(mseconds, 123, foo) from tbl1;
select dateadd(millisec, 123, foo) from tbl1;
select dateadd(millisecs, 123, foo) from tbl1;
select dateadd(millisecon, 123, foo) from tbl1;
select dateadd(microsecond, 123, foo) from tbl1;
select dateadd(microseconds, 123, foo) from tbl1;
select datediff(microsec, foo, bar) from tbl1;
select datediff(microsecs, foo, bar) from tbl1;
select datediff(microsecond, foo, bar) from tbl1;
select datediff(usecond, foo, bar) from tbl1;
select datediff(useconds, foo, bar) from tbl1;
select datediff(us, foo, bar) from tbl1;
select datediff(usec, foo, bar) from tbl1;
select datediff(usecs, foo, bar) from tbl1;
select datediff(timezone, foo, bar) from tbl1;
select datediff(timezone_hour, foo, bar) from tbl1;
select datediff(timezone_minute, foo, bar) from tbl1;
|
