Commit8c3fff7

Thomas G. Lockhart

committed

Fix offset of one for date_part(timespan) when given arguments of

decade, century, or millenium.

1 parentba71b81 commit8c3fff7Copy full SHA for 8c3fff7

File tree

-4

lines changed

-4

lines changed

Lines changed: 4 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -7,7 +7,7 @@`
`7`	`7`	`*`
`8`	`8`	`*`
`9`	`9`	`* IDENTIFICATION`
`10`		`- * $Header: /cvsroot/pgsql/src/backend/utils/adt/Attic/dt.c,v 1.63 1999/02/1304:25:01 thomas Exp $`
	`10`	`+ * $Header: /cvsroot/pgsql/src/backend/utils/adt/Attic/dt.c,v 1.64 1999/02/1305:34:24 thomas Exp $`
`11`	`11`	`*`
`12`	`12`	`*-------------------------------------------------------------------------`
`13`	`13`	`*/`
`@@ -1744,15 +1744,15 @@ datetime_part(text units, DateTime datetime)`
`1744`	`1744`	`break;`
`1745`	`1745`
`1746`	`1746`	`caseDTK_DECADE:`
`1747`		`-*result= (tm->tm_year /10)+1;`
	`1747`	`+*result= (tm->tm_year /10);`
`1748`	`1748`	`break;`
`1749`	`1749`
`1750`	`1750`	`caseDTK_CENTURY:`
`1751`		`-*result= (tm->tm_year /100)+1;`
	`1751`	`+*result= (tm->tm_year /100);`
`1752`	`1752`	`break;`
`1753`	`1753`
`1754`	`1754`	`caseDTK_MILLENIUM:`
`1755`		`-*result= (tm->tm_year /1000)+1;`
	`1755`	`+*result= (tm->tm_year /1000);`
`1756`	`1756`	`break;`
`1757`	`1757`
`1758`	`1758`	`default:`

Comments

(0)