2 PostgreSQL Data Base Management System (formerly known as Postgres, then
5 Copyright (c) 1994-7 Regents of the University of California
7 Permission to use, copy, modify, and distribute this software and its
8 documentation for any purpose, without fee, and without a written agreement
9 is hereby granted, provided that the above copyright notice and this
10 paragraph and the following two paragraphs appear in all copies.
12 IN NO EVENT SHALL THE UNIVERSITY OF CALIFORNIA BE LIABLE TO ANY PARTY FOR
13 DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING
14 LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS
15 DOCUMENTATION, EVEN IF THE UNIVERSITY OF CALIFORNIA HAS BEEN ADVISED OF THE
16 POSSIBILITY OF SUCH DAMAGE.
18 THE UNIVERSITY OF CALIFORNIA SPECIFICALLY DISCLAIMS ANY WARRANTIES,
19 INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY
20 AND FITNESS FOR A PARTICULAR PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS
21 ON AN "AS IS" BASIS, AND THE UNIVERSITY OF CALIFORNIA HAS NO OBLIGATIONS TO
22 PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.
24 /*-------------------------------------------------------------------------
27 * Definitions for the date/time and other date/time support code.
28 * The support code is shared with other date data types,
29 * including abstime, reltime, date, and time.
32 * Copyright (c) 1994, Regents of the University of California
34 *-------------------------------------------------------------------------
42 /* We have to include stdlib.h here because it defines many of these macros
43 on some platforms, and we only want our definitions used if stdlib.h doesn't
53 /* ----------------------------------------------------------------
54 * Section 1: bool, true, false, TRUE, FALSE
55 * ----------------------------------------------------------------
59 * Boolean value, either true or false.
62 #define false ((char) 0)
63 #define true ((char) 1)
67 #endif /* ndef bool */
69 typedef bool *BoolPtr
;
81 /* ----------------------------------------------------------------
82 * Section 3: standard system types
83 * ----------------------------------------------------------------
88 * Signed integer, EXACTLY N BITS IN SIZE,
89 * used for numerical computations and the
90 * frontend/backend protocol.
92 typedef signed char int8
; /* == 8 bits */
93 typedef signed short int16
; /* == 16 bits */
94 typedef signed int int32
; /* == 32 bits */
98 * Unsigned integer, EXACTLY N BITS IN SIZE,
99 * used for numerical computations and the
100 * frontend/backend protocol.
102 typedef unsigned char uint8
; /* == 8 bits */
103 typedef unsigned short uint16
; /* == 16 bits */
104 typedef unsigned int uint32
; /* == 32 bits */
108 * Floating point number, AT LEAST N BITS IN SIZE,
109 * used for numerical computations.
111 * Since sizeof(floatN) may be > sizeof(char *), always pass
112 * floatN by reference.
114 typedef float float32data
;
115 typedef double float64data
;
116 typedef float *float32
;
117 typedef double *float64
;
121 * Boolean value, AT LEAST N BITS IN SIZE.
123 typedef uint8 bool8
; /* >= 8 bits */
124 typedef uint16 bool16
; /* >= 16 bits */
125 typedef uint32 bool32
; /* >= 32 bits */
128 /* Date/Time Configuration
130 * Constants to pass info from runtime environment:
131 * USE_POSTGRES_DATES specifies traditional postgres format for output.
132 * USE_ISO_DATES specifies ISO-compliant format for output.
133 * USE_SQL_DATES specified Oracle/Ingres-compliant format for output.
134 * USE_GERMAN_DATES specifies German-style dd.mm/yyyy date format.
136 * DateStyle specifies preference for date formatting for output.
137 * EuroDates if client prefers dates interpreted and written w/European conventions.
139 * HasCTZSet if client timezone is specified by client.
140 * CDayLight is the apparent daylight savings time status.
141 * CTimeZone is the timezone offset in seconds.
142 * CTZName is the timezone label.
145 #define USE_POSTGRES_DATES 0
146 #define USE_ISO_DATES 1
147 #define USE_SQL_DATES 2
148 #define USE_GERMAN_DATES 3
150 extern int DateStyle
;
151 extern bool EuroDates
;
152 extern int CTimeZone
;
154 typedef double float8
;
162 typedef struct varlena text
;
166 typedef int AbsoluteTime
;
167 typedef int RelativeTime
;
170 * Note a leap year is one that is a multiple of 4
171 * but not of a 100. Except if it is a multiple of
172 * 400 then it is a leap year.
174 #define isleap(y) (((y % 4) == 0) && (((y % 100) != 0) || ((y % 400) == 0)))
177 * DateTime represents absolute time.
178 * TimeSpan represents delta time. Keep track of months (and years)
179 * separately since the elapsed time spanned is unknown until instantiated
180 * relative to an absolute time.
182 * Note that Postgres uses "time interval" to mean a bounded interval,
183 * consisting of a beginning and ending time, not a time span - thomas 97/03/20
186 typedef double DateTime
;
190 double time
; /* all time units other than months and
192 int month
; /* months and years, after time for
197 /* ----------------------------------------------------------------
198 * time types + support macros
200 * String definitions for standard time quantities.
202 * These strings are the defaults used to form output time strings.
203 * Other alternate forms are hardcoded into token tables in dt.c.
204 * ----------------------------------------------------------------
208 #define DCURRENT "current"
209 #define EPOCH "epoch"
210 #define INVALID "invalid"
211 #define EARLY "-infinity"
212 #define LATE "infinity"
214 #define TODAY "today"
215 #define TOMORROW "tomorrow"
216 #define YESTERDAY "yesterday"
219 #define DMICROSEC "usecond"
220 #define DMILLISEC "msecond"
221 #define DSECOND "second"
222 #define DMINUTE "minute"
226 #define DMONTH "month"
227 #define DQUARTER "quarter"
229 #define DDECADE "decade"
230 #define DCENTURY "century"
231 #define DMILLENIUM "millenium"
234 #define DTIMEZONE "timezone"
237 * Fundamental time field definitions for parsing.
239 * Meridian: am, pm, or 24-hour style.
251 * Fields for time decoding.
252 * Can't have more of these than there are bits in an unsigned int
253 * since these are turned into bit masks during parsing and decoding.
260 #define TIMES 4 /* not used - thomas 1997-07-14 */
264 #define IGNOREFIELD 8
273 /* these are only for relative dates */
275 #define ABS_BEFORE 18
279 * Token field definitions for time parsing and decoding.
280 * These need to fit into the datetkn table type.
281 * At the moment, that means keep them within [-127,127].
282 * These are also used for bit masks in DecodeDateDelta()
283 * so actually restrict them to within [0,31] for now.
285 * Not all of these fields are used for masks in DecodeDateDelta
286 * so allow some larger than 31. - thomas 1997-11-17
297 #define DTK_SPECIAL 6
298 #define DTK_INVALID 7
299 #define DTK_CURRENT 8
304 #define DTK_YESTERDAY 13
306 #define DTK_TOMORROW 15
310 #define DTK_SECOND 18
311 #define DTK_MINUTE 19
316 #define DTK_QUARTER 24
318 #define DTK_DECADE 26
319 #define DTK_CENTURY 27
320 #define DTK_MILLENIUM 28
321 #define DTK_MILLISEC 29
322 #define DTK_MICROSEC 30
326 #define DTK_TZ_HOUR 34
327 #define DTK_TZ_MINUTE 35
330 * Bit mask definitions for time parsing.
333 #define DTK_M(t) (0x01 << (t))
335 #define DTK_DATE_M (DTK_M(YEAR) | DTK_M(MONTH) | DTK_M(DAY))
336 #define DTK_TIME_M (DTK_M(HOUR) | DTK_M(MINUTE) | DTK_M(SECOND))
338 #define MAXDATELEN 47 /* maximum possible length of an input
340 #define MAXDATEFIELDS 25 /* maximum possible number of fields in a
342 #define TOKMAXLEN 10 /* only this many chars are stored in
345 /* keep this struct small; it gets used a lot */
351 char token
[TOKMAXLEN
];
354 char value
; /* this may be unsigned, alas */
364 void j2date(int jd
, int *year
, int *month
, int *day
);
365 int date2j(int year
, int month
, int day
);
367 int ParseDateTime(char *timestr
, char *lowstr
,
368 char **field
, int *ftype
, int maxfields
, int *numfields
);
369 int DecodeDateTime(char **field
, int *ftype
,
370 int nf
, int *dtype
, struct tm
* tm
, double *fsec
, int *tzp
);
372 int DecodeTimeOnly(char **field
, int *ftype
, int nf
,
373 int *dtype
, struct tm
* tm
, double *fsec
);
374 BOOL
DateToTm( DATE dateIn
, DWORD dwFlags
, struct tm
* pTm
);