postgres.git / summary / log / commit / refs

commit    fa67e2ce4f80ad7ac063da041d1cb4ca9ff4c06d
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Thu Jul 24 00:21:31 2003 +0000
First released in: 7.4, 7.3.4

    Repair 7.3 breakage in timestamp-to-date conversion for dates before 2000.


 src/backend/utils/adt/date.c | 16 ++++++++--------
 1 file changed, 8 insertions(+), 8 deletions(-)

diff --git a/src/backend/utils/adt/date.c b/src/backend/utils/adt/date.c
index 1bcd6726aea..347d82be07a 100644
--- a/src/backend/utils/adt/date.c
+++ b/src/backend/utils/adt/date.c
@@ -8,7 +8,7 @@
  *
  *
  * IDENTIFICATION
- *	  $Header: /cvsroot/pgsql/src/backend/utils/adt/date.c,v 1.73.2.5 2003/06/16 18:56:53 tgl Exp $
+ *	  $Header: /cvsroot/pgsql/src/backend/utils/adt/date.c,v 1.73.2.6 2003/07/24 00:21:31 tgl Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -319,17 +319,17 @@ timestamp_date(PG_FUNCTION_ARGS)
 {
 	Timestamp	timestamp = PG_GETARG_TIMESTAMP(0);
 	DateADT		result;
+	struct tm	tt,
+			   *tm = &tt;
+	double		fsec;
 
 	if (TIMESTAMP_NOT_FINITE(timestamp))
 		PG_RETURN_NULL();
 
-#ifdef HAVE_INT64_TIMESTAMP
-	/* Microseconds to days */
-	result = (timestamp / INT64CONST(86400000000));
-#else
-	/* Seconds to days */
-	result = (timestamp / 86400.0);
-#endif
+	if (timestamp2tm(timestamp, NULL, tm, &fsec, NULL) != 0)
+		elog(ERROR, "Unable to convert timestamp to date");
+
+	result = date2j(tm->tm_year, tm->tm_mon, tm->tm_mday) - date2j(2000, 1, 1);
 
 	PG_RETURN_DATEADT(result);
 }


[parent: 83bc9b9d2ef0]