Commitf8d4b3c

Thomas G. Lockhart

committed

Fix expected output for datetime and abstime to/from date conversions.

This results from improvements in datetime.c which ensures that the conversions are done in local time rather than GMT.

1 parente35b759 commitf8d4b3cCopy full SHA for f8d4b3c

File tree

+10

-10

lines changed

+10

-10

lines changed

Lines changed: 10 additions & 10 deletions

Original file line number	Diff line number	Diff line change
`@@ -442,16 +442,16 @@ QUERY: SELECT '' AS ten, f1 AS datetime, date( f1) AS date`
`442`	`442`	`ORDER BY date;`
`443`	`443`	`ten\|datetime \| date`
`444`	`444`	`---+-------------------------------+----------`
`445`		`- \|Wed Feb 28 17:32:01.00 1996 PST\|02-29-1996`
`446`		`- \|Thu Feb29 17:32:01.00 1996 PST\|03-01-1996`
`447`		`- \|Fri Mar 01 17:32:01.00 1996 PST\|03-02-1996`
`448`		`- \|Mon Dec 30 17:32:01.00 1996 PST\|12-31-1996`
`449`		`- \|Tue Dec31 17:32:01.00 1996 PST\|01-01-1997`
`450`		`- \|Fri Dec 31 17:32:01.001999 PST\|01-01-2000`
`451`		`- \|epoch \|01-01-2000`
`452`		`- \|Sat Jan 01 17:32:01.00 2000 PST\|01-02-2000`
`453`		`- \|Sun Dec 31 17:32:01.00 2000 PST\|01-01-2001`
`454`		`- \|Mon Jan 01 17:32:01.00 2001 PST\|01-02-2001`
	`445`	`+ \|epoch \|01-01-1970`
	`446`	`+ \|Wed Feb28 17:32:01.00 1996 PST\|02-28-1996`
	`447`	`+ \|Thu Feb 29 17:32:01.00 1996 PST\|02-29-1996`
	`448`	`+ \|Fri Mar 01 17:32:01.00 1996 PST\|03-01-1996`
	`449`	`+ \|Mon Dec30 17:32:01.00 1996 PST\|12-30-1996`
	`450`	`+ \|Tue Dec 31 17:32:01.001996 PST\|12-31-1996`
	`451`	`+ \|Fri Dec 31 17:32:01.00 1999 PST\|12-31-1999`
	`452`	`+ \|Sat Jan 01 17:32:01.00 2000 PST\|01-01-2000`
	`453`	`+ \|Sun Dec 31 17:32:01.00 2000 PST\|12-31-2000`
	`454`	`+ \|Mon Jan 01 17:32:01.00 2001 PST\|01-01-2001`
`455`	`455`	`(10 rows)`
`456`	`456`
`457`	`457`	`QUERY: SELECT '' AS ten, f1 AS datetime, abstime( f1) AS abstime`

Comments

(0)