Commite2639a7

committed

Make extract(timetz) tests a bit more interesting

Use a time zone offset with nonzero minutes to make thetimezone_minute test meaningful.

1 parentffd3391 commite2639a7Copy full SHA for e2639a7

File tree

-8

lines changed

-8

lines changed

Lines changed: 5 additions & 5 deletions

Original file line number	Diff line number	Diff line change
`@@ -181,22 +181,22 @@ SELECT EXTRACT(DAY FROM TIME WITH TIME ZONE '2020-05-26 13:30:25.575401-`
`181`	`181`	`ERROR: "time with time zone" units "day" not recognized`
`182`	`182`	`SELECT EXTRACT(FORTNIGHT FROM TIME WITH TIME ZONE '2020-05-26 13:30:25.575401-04'); -- error`
`183`	`183`	`ERROR: "time with time zone" units "fortnight" not recognized`
`184`		`-SELECT EXTRACT(TIMEZONE FROM TIME WITH TIME ZONE '2020-05-26 13:30:25.575401-04');`
	`184`	`+SELECT EXTRACT(TIMEZONE FROM TIME WITH TIME ZONE '2020-05-26 13:30:25.575401-04:30');`
`185`	`185`	`date_part`
`186`	`186`	`-----------`
`187`		`- -14400`
	`187`	`+ -16200`
`188`	`188`	`(1 row)`
`189`	`189`
`190`		`-SELECT EXTRACT(TIMEZONE_HOUR FROM TIME WITH TIME ZONE '2020-05-26 13:30:25.575401-04');`
	`190`	`+SELECT EXTRACT(TIMEZONE_HOUR FROM TIME WITH TIME ZONE '2020-05-26 13:30:25.575401-04:30');`
`191`	`191`	`date_part`
`192`	`192`	`-----------`
`193`	`193`	`-4`
`194`	`194`	`(1 row)`
`195`	`195`
`196`		`-SELECT EXTRACT(TIMEZONE_MINUTE FROM TIME WITH TIME ZONE '2020-05-26 13:30:25.575401-04');`
	`196`	`+SELECT EXTRACT(TIMEZONE_MINUTE FROM TIME WITH TIME ZONE '2020-05-26 13:30:25.575401-04:30');`
`197`	`197`	`date_part`
`198`	`198`	`-----------`
`199`		`- 0`
	`199`	`+-30`
`200`	`200`	`(1 row)`
`201`	`201`
`202`	`202`	`SELECT EXTRACT(EPOCH FROM TIME WITH TIME ZONE '2020-05-26 13:30:25.575401-04');`

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -66,7 +66,7 @@ SELECT EXTRACT(MINUTE FROM TIME WITH TIME ZONE '2020-05-26 13:30:25.575401-`
`66`	`66`	`SELECT EXTRACT(HOURFROMTIME WITH TIME ZONE'2020-05-26 13:30:25.575401-04');`
`67`	`67`	`SELECT EXTRACT(DAYFROMTIME WITH TIME ZONE'2020-05-26 13:30:25.575401-04');-- error`
`68`	`68`	`SELECT EXTRACT(FORTNIGHTFROMTIME WITH TIME ZONE'2020-05-26 13:30:25.575401-04');-- error`
`69`		`-SELECT EXTRACT(TIMEZONEFROMTIME WITH TIME ZONE'2020-05-26 13:30:25.575401-04');`
`70`		`-SELECT EXTRACT(TIMEZONE_HOURFROMTIME WITH TIME ZONE'2020-05-26 13:30:25.575401-04');`
`71`		`-SELECT EXTRACT(TIMEZONE_MINUTEFROMTIME WITH TIME ZONE'2020-05-26 13:30:25.575401-04');`
	`69`	`+SELECT EXTRACT(TIMEZONEFROMTIME WITH TIME ZONE'2020-05-26 13:30:25.575401-04:30');`
	`70`	`+SELECT EXTRACT(TIMEZONE_HOURFROMTIME WITH TIME ZONE'2020-05-26 13:30:25.575401-04:30');`
	`71`	`+SELECT EXTRACT(TIMEZONE_MINUTEFROMTIME WITH TIME ZONE'2020-05-26 13:30:25.575401-04:30');`
`72`	`72`	`SELECT EXTRACT(EPOCHFROMTIME WITH TIME ZONE'2020-05-26 13:30:25.575401-04');`

Comments

(0)