From: Thomas Lockhart <Thomas.G.Lockhart@jpl.nasa.gov>

Subject: [HACKERS] More patches for date/time

I have accumulated several patches to add functionality to the datetime
and timespan data types as well as to fix reported porting bugs on non-BSD
machines. These patches are:

dt.c.patch              - add datetime_part(), fix bugs
dt.h.patch              - add quarter and timezone support, add prototypes
globals.c.patch         - add time and timezone variables
miscadmin.h.patch       - add time and timezone variables
nabstime.c.patch        - add datetime conversion routine
nabstime.h.patch        - add prototypes
pg_operator.h.patch     - add datetime operators, clean up formatting
pg_proc.h.patch         - add datetime functions, reassign conflicting date OIDs
pg_type.h.patch         - add datetime and timespan data types

The dt.c and pg_proc.h patches are fairly large; the latter mostly because I tried
to get some columns for existing entries to line up.

1 files changed, 18 insertions, 2 deletions

diff --git a/src/include/miscadmin.h b/src/include/miscadmin.h
index a7648feb99..9e3473a0d2 100644
--- a/src/include/miscadmin.h
+++ b/src/include/miscadmin.h
@@ -11,7 +11,7 @@
  *
  * Copyright (c) 1994, Regents of the University of California
  *
- * $Id: miscadmin.h,v 1.7 1997/03/18 20:15:19 scrappy Exp $
+ * $Id: miscadmin.h,v 1.8 1997/03/25 08:09:59 scrappy Exp $
  *
  * NOTES
  *    some of the information in this file will be moved to
@@ -58,12 +58,28 @@ extern bool	    IsPostmaster;
 extern short	    DebugLvl;
 
 /* Date/Time Configuration
- * HasCTZSet if client timezone is specified by client.
+ *
+ * Constants to pass info from runtime environment:
+ *  USE_POSTGRES_DATES specifies traditional postgres format for output.
+ *  USE_ISO_DATES specifies ISO-compliant format for output.
+ *  USE_SQL_DATES specified Oracle/Ingres-compliant format for output.
+ *
+ * DateStyle specifies preference for date formatting for output.
  * EuroDates if client prefers dates interpreted and written w/European conventions.
+ *
+ * HasCTZSet if client timezone is specified by client.
+ * CDayLight is the apparent daylight savings time status.
  * CTimeZone is the timezone offset in seconds.
  * CTZName is the timezone label.
  */
 
+#define MAXTZLEN	7
+
+#define USE_POSTGRES_DATES	0
+#define USE_ISO_DATES		1
+#define USE_SQL_DATES		2
+
+extern int	    DateStyle;
 extern bool	    EuroDates;
 extern bool	    HasCTZSet;
 extern bool	    CDayLight;