From 89a99cb68612d3cda1d0707988b5e1227b6b9320 Mon Sep 17 00:00:00 2001
From: "Thomas G. Lockhart" <lockhart@fourpalms.org>
Date: Sat, 11 Nov 2000 19:55:19 +0000
Subject: Allow interpretation of INTERVALs with more timezone-like syntax.
 Define conversions to and from text for date, time, and timetz. Have
 millisecond and microsecond return full # of seconds in those units. 
 Previously, only returned full fractional part in those units.

---
 src/backend/utils/adt/timestamp.c | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

(limited to 'src/backend/utils/adt/timestamp.c')

diff --git a/src/backend/utils/adt/timestamp.c b/src/backend/utils/adt/timestamp.c
index ab147d295b5..4478dc95efa 100644
--- a/src/backend/utils/adt/timestamp.c
+++ b/src/backend/utils/adt/timestamp.c
@@ -8,7 +8,7 @@
  *
  *
  * IDENTIFICATION
- *	  $Header: /cvsroot/pgsql/src/backend/utils/adt/timestamp.c,v 1.37 2000/11/06 15:57:00 thomas Exp $
+ *	  $Header: /cvsroot/pgsql/src/backend/utils/adt/timestamp.c,v 1.38 2000/11/11 19:55:19 thomas Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -2100,11 +2100,11 @@ interval_part(PG_FUNCTION_ARGS)
 			switch (val)
 			{
 				case DTK_MICROSEC:
-					result = (fsec * 1000000);
+					result = ((tm->tm_sec + fsec) * 1000000);
 					break;
 
 				case DTK_MILLISEC:
-					result = (fsec * 1000);
+					result = ((tm->tm_sec + fsec) * 1000);
 					break;
 
 				case DTK_SECOND:
-- 
cgit v1.2.3