blob: 70c7e5eac23d74bb97e36292a036cc0dd95539df (
plain)
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
|
.pgaw:Help.f.t insert end \
"DateTime functions\n\n" {title} \
"abstime(datetime) " {bold} "
Returns: abstime
convert to abstime
" {} "age(datetime,datetime) " {bold} "
Returns: timespan
preserve months and years
" {} "datetime(abstime) " {bold} "
Returns: datetime
convert to datetime
" {} "datetime(date) " {bold} "
Returns: datetime
convert to datetime
" {} "datetime(date,time) " {bold} "
Returns: datetime
convert to datetime
" {} "date_part(text,datetime) " {bold} "
Returns: float8
portion of date
" {} "date_part(text,timespan) " {bold} "
Returns: float8
portion of time
" {} "date_trunc(text,datetime) " {bold} "
Returns: datetime
truncate date
" {} "isfinite(abstime) " {bold} "
Returns: bool
a finite time?
" {} "isfinite(datetime) " {bold} "
Returns: bool
a finite time?
" {} "isfinite(timespan) " {bold} "
Returns: bool
a finite time?
" {} "reltime(timespan) " {bold} "
Returns: reltime
convert to reltime
" {} "timespan(reltime) " {bold} "
Returns: timespan
convert to timespan
" {} \
"PostgreSQL functions\n" {link pgfunctions} \
"Next - geometric functions" {link geomfunc}
|
