Commit4c862b1

committed

Display only 9 not 10 digits of precision for timestamp values when

using non-integer timestamps. This prevents the display of roundingerrors for common values like days < 32.

1 parentb3195da commit4c862b1Copy full SHA for 4c862b1

File tree

-4

lines changed

src
- backend/utils/adt
  - datetime.c
- interfaces/ecpg/pgtypeslib
  - interval.c

-4

lines changed

Lines changed: 3 additions & 3 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/datetime.c,v 1.145 2005/05/2602:04:13 neilc Exp $`
	`11`	`+ * $PostgreSQL: pgsql/src/backend/utils/adt/datetime.c,v 1.146 2005/05/2603:48:25 momjian Exp $`
`12`	`12`	`*`
`13`	`13`	`*-------------------------------------------------------------------------`
`14`	`14`	`*/`
`@@ -3461,7 +3461,7 @@ EncodeTimeOnly(struct pg_tm * tm, fsec_t fsec, int tzp, int style, char str)`
`3461`	`3461`	`#ifdefHAVE_INT64_TIMESTAMP`
`3462`	`3462`	`sprintf(str+strlen(str),":%02d.%06d",tm->tm_sec,fsec);`
`3463`	`3463`	`#else`
`3464`		`-sprintf(str+strlen(str),":%013.10f",tm->tm_sec+fsec);`
	`3464`	`+sprintf(str+strlen(str),":%012.9f",tm->tm_sec+fsec);`
`3465`	`3465`	`#endif`
`3466`	`3466`	`/* chop off trailing pairs of zeros... */`
`3467`	`3467`	`while (strcmp((str+strlen(str)-2),"00")==0&&`
`@@ -3804,7 +3804,7 @@ EncodeInterval(struct pg_tm * tm, fsec_t fsec, int style, char *str)`
`3804`	`3804`	`sprintf(cp,".%06d",Abs(fsec));`
`3805`	`3805`	`#else`
`3806`	`3806`	`fsec+=tm->tm_sec;`
`3807`		`-sprintf(cp,":%013.10f",fabs(fsec));`
	`3807`	`+sprintf(cp,":%012.9f",fabs(fsec));`
`3808`	`3808`	`#endif`
`3809`	`3809`	`TrimTrailingZeros(cp);`
`3810`	`3810`	`cp+=strlen(cp);`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -511,7 +511,7 @@ EncodeInterval(struct tm * tm, fsec_t fsec, int style, char *str)`
`511`	`511`	`sprintf(cp,".%06d", (fsec >=0) ?fsec :-(fsec));`
`512`	`512`	`#else`
`513`	`513`	`fsec+=tm->tm_sec;`
`514`		`-sprintf(cp,":%013.10f",fabs(fsec));`
	`514`	`+sprintf(cp,":%012.9f",fabs(fsec));`
`515`	`515`	`#endif`
`516`	`516`	`TrimTrailingZeros(cp);`
`517`	`517`	`cp+=strlen(cp);`

Comments

(0)