Commitc584103

committed

Patch of 2004-03-30 corrected date_part(timestamp) for extracting

the year from a BC date, but failed to make the same fix indate_part(timestamptz).

1 parent19dacd4 commitc584103Copy full SHA for c584103

File tree

-2

lines changed

-2

lines changed

Lines changed: 6 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -8,7 +8,7 @@`
`8`	`8`	`*`
`9`	`9`	`*`
`10`	`10`	`* IDENTIFICATION`
`11`		`- * $PostgreSQL: pgsql/src/backend/utils/adt/timestamp.c,v 1.114 2004/11/01 22:00:30 tgl Exp $`
	`11`	`+ * $PostgreSQL: pgsql/src/backend/utils/adt/timestamp.c,v 1.115 2004/11/20 22:12:44 tgl Exp $`
`12`	`12`	`*`
`13`	`13`	`*-------------------------------------------------------------------------`
`14`	`14`	`*/`
`@@ -3534,7 +3534,11 @@ timestamptz_part(PG_FUNCTION_ARGS)`
`3534`	`3534`	`break;`
`3535`	`3535`
`3536`	`3536`	`caseDTK_YEAR:`
`3537`		`-result=tm->tm_year;`
	`3537`	`+if (tm->tm_year>0)`
	`3538`	`+result=tm->tm_year;`
	`3539`	`+else`
	`3540`	`+/* there is no year 0, just 1 BC and 1 AD */`
	`3541`	`+result=tm->tm_year-1;`
`3538`	`3542`	`break;`
`3539`	`3543`
`3540`	`3544`	`caseDTK_DECADE:`

Comments

(0)