File: test_icu_cast.test

package info (click to toggle)
duckdb 1.5.1-3
  • links: PTS, VCS
  • area: main
  • in suites:
  • size: 299,196 kB
  • sloc: cpp: 865,414; ansic: 57,292; python: 18,871; sql: 12,663; lisp: 11,751; yacc: 7,412; lex: 1,682; sh: 747; makefile: 564
file content (21 lines) | stat: -rw-r--r-- 350 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
 
# name: test/sql/function/timetz/test_icu_cast.test
# description: Test default TIMETZ offsets with ICU loaded.
# group: [timetz]

require icu

statement ok
SET CALENDAR='gregorian';

statement ok
SET TIMEZONE='America/Phoenix';

query I
SELECT '01:00:00'::TIMETZ AS ttz
----
01:00:00-07

query I
SELECT '01:00:00+02'::TIMETZ AS ttz
----
01:00:00+02