Commitc859ff9

Thomas G. Lockhart

committed

Fix queries to insulate from daylight savings time.

1 parent57584d7 commitc859ff9Copy full SHA for c859ff9

File tree

-8

lines changed

-8

lines changed

Lines changed: 4 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -27,15 +27,15 @@ SELECT f1 AS "Time TZ" FROM TIMETZ_TBL;`
`27`	`27`	`23:59:59.99-07`
`28`	`28`	`(10 rows)`
`29`	`29`
`30`		`-SELECT f1 AS "Three" FROM TIMETZ_TBL WHERE f1 < '05:06:07';`
	`30`	`+SELECT f1 AS "Three" FROM TIMETZ_TBL WHERE f1 < '05:06:07-07';`
`31`	`31`	`Three`
`32`	`32`	`-------------`
`33`	`33`	`00:01:00-07`
`34`	`34`	`01:00:00-07`
`35`	`35`	`02:03:00-07`
`36`	`36`	`(3 rows)`
`37`	`37`
`38`		`-SELECT f1 AS "Seven" FROM TIMETZ_TBL WHERE f1 > '05:06:07';`
	`38`	`+SELECT f1 AS "Seven" FROM TIMETZ_TBL WHERE f1 > '05:06:07-07';`
`39`	`39`	`Seven`
`40`	`40`	`----------------`
`41`	`41`	`07:07:00-08`
`@@ -47,12 +47,12 @@ SELECT f1 AS "Seven" FROM TIMETZ_TBL WHERE f1 > '05:06:07';`
`47`	`47`	`23:59:59.99-07`
`48`	`48`	`(7 rows)`
`49`	`49`
`50`		`-SELECT f1 AS "None" FROM TIMETZ_TBL WHERE f1 < '00:00';`
	`50`	`+SELECT f1 AS "None" FROM TIMETZ_TBL WHERE f1 < '00:00-07';`
`51`	`51`	`None`
`52`	`52`	`------`
`53`	`53`	`(0 rows)`
`54`	`54`
`55`		`-SELECT f1 AS "Ten" FROM TIMETZ_TBL WHERE f1 >= '00:00';`
	`55`	`+SELECT f1 AS "Ten" FROM TIMETZ_TBL WHERE f1 >= '00:00-07';`
`56`	`56`	`Ten`
`57`	`57`	`----------------`
`58`	`58`	`00:01:00-07`

Lines changed: 4 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -17,13 +17,13 @@ INSERT INTO TIMETZ_TBL VALUES ('11:59:59.99 PM PDT');`
`17`	`17`
`18`	`18`	`SELECT f1AS"Time TZ"FROM TIMETZ_TBL;`
`19`	`19`
`20`		`-SELECT f1AS"Three"FROM TIMETZ_TBLWHERE f1<'05:06:07';`
	`20`	`+SELECT f1AS"Three"FROM TIMETZ_TBLWHERE f1<'05:06:07-07';`
`21`	`21`
`22`		`-SELECT f1AS"Seven"FROM TIMETZ_TBLWHERE f1>'05:06:07';`
	`22`	`+SELECT f1AS"Seven"FROM TIMETZ_TBLWHERE f1>'05:06:07-07';`
`23`	`23`
`24`		`-SELECT f1AS"None"FROM TIMETZ_TBLWHERE f1<'00:00';`
	`24`	`+SELECT f1AS"None"FROM TIMETZ_TBLWHERE f1<'00:00-07';`
`25`	`25`
`26`		`-SELECT f1AS"Ten"FROM TIMETZ_TBLWHERE f1>='00:00';`
	`26`	`+SELECT f1AS"Ten"FROM TIMETZ_TBLWHERE f1>='00:00-07';`
`27`	`27`
`28`	`28`	`--`
`29`	`29`	`-- TIME simple math`

Comments

(0)