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
|
# name: test/sql/function/timestamp/current_timestamp.test
# description: Test current_time/current_date/etc
# group: [timestamp]
require icu
# Normalise the testing locale
statement ok
SET Calendar = 'gregorian';
statement ok
SET TimeZone = 'America/Chihuahua';
statement ok
PRAGMA enable_verification
# get the millennium of the current date
# FIXME: this needs to be updated in 982 years
query I
SELECT EXTRACT(MILLENNIUM FROM NOW())
----
3
query I
SELECT SUFFIX(CURRENT_TIMESTAMP::VARCHAR, '-06');
----
True
foreach func now get_current_timestamp transaction_timestamp
query I
SELECT SUFFIX(${func}()::VARCHAR, '-06');
----
True
endloop
# Ago is a macro based on current_timestamp
foreach unit millennia century decade year month day hour minute second
query II
select
current_timestamp - interval 1 ${unit} = ago(interval 1 ${unit}),
current_timestamp - interval 1 ${unit} = ago('1 ${unit}');
----
True True
endloop
|
