gooderp18绿色标准版
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

110 lines
3.9KB

  1. /*-------------------------------------------------------------------------
  2. *
  3. * timestamp.h
  4. * Definitions for the SQL "timestamp" and "interval" types.
  5. *
  6. * Portions Copyright (c) 1996-2019, PostgreSQL Global Development Group
  7. * Portions Copyright (c) 1994, Regents of the University of California
  8. *
  9. * src/include/utils/timestamp.h
  10. *
  11. *-------------------------------------------------------------------------
  12. */
  13. #ifndef TIMESTAMP_H
  14. #define TIMESTAMP_H
  15. #include "datatype/timestamp.h"
  16. #include "fmgr.h"
  17. #include "pgtime.h"
  18. /*
  19. * Macros for fmgr-callable functions.
  20. *
  21. * For Timestamp, we make use of the same support routines as for int64.
  22. * Therefore Timestamp is pass-by-reference if and only if int64 is!
  23. */
  24. #define DatumGetTimestamp(X) ((Timestamp) DatumGetInt64(X))
  25. #define DatumGetTimestampTz(X) ((TimestampTz) DatumGetInt64(X))
  26. #define DatumGetIntervalP(X) ((Interval *) DatumGetPointer(X))
  27. #define TimestampGetDatum(X) Int64GetDatum(X)
  28. #define TimestampTzGetDatum(X) Int64GetDatum(X)
  29. #define IntervalPGetDatum(X) PointerGetDatum(X)
  30. #define PG_GETARG_TIMESTAMP(n) DatumGetTimestamp(PG_GETARG_DATUM(n))
  31. #define PG_GETARG_TIMESTAMPTZ(n) DatumGetTimestampTz(PG_GETARG_DATUM(n))
  32. #define PG_GETARG_INTERVAL_P(n) DatumGetIntervalP(PG_GETARG_DATUM(n))
  33. #define PG_RETURN_TIMESTAMP(x) return TimestampGetDatum(x)
  34. #define PG_RETURN_TIMESTAMPTZ(x) return TimestampTzGetDatum(x)
  35. #define PG_RETURN_INTERVAL_P(x) return IntervalPGetDatum(x)
  36. #define TIMESTAMP_MASK(b) (1 << (b))
  37. #define INTERVAL_MASK(b) (1 << (b))
  38. /* Macros to handle packing and unpacking the typmod field for intervals */
  39. #define INTERVAL_FULL_RANGE (0x7FFF)
  40. #define INTERVAL_RANGE_MASK (0x7FFF)
  41. #define INTERVAL_FULL_PRECISION (0xFFFF)
  42. #define INTERVAL_PRECISION_MASK (0xFFFF)
  43. #define INTERVAL_TYPMOD(p,r) ((((r) & INTERVAL_RANGE_MASK) << 16) | ((p) & INTERVAL_PRECISION_MASK))
  44. #define INTERVAL_PRECISION(t) ((t) & INTERVAL_PRECISION_MASK)
  45. #define INTERVAL_RANGE(t) (((t) >> 16) & INTERVAL_RANGE_MASK)
  46. #define TimestampTzPlusMilliseconds(tz,ms) ((tz) + ((ms) * (int64) 1000))
  47. /* Set at postmaster start */
  48. extern TimestampTz PgStartTime;
  49. /* Set at configuration reload */
  50. extern TimestampTz PgReloadTime;
  51. /* Internal routines (not fmgr-callable) */
  52. extern int32 anytimestamp_typmod_check(bool istz, int32 typmod);
  53. extern TimestampTz GetCurrentTimestamp(void);
  54. extern TimestampTz GetSQLCurrentTimestamp(int32 typmod);
  55. extern Timestamp GetSQLLocalTimestamp(int32 typmod);
  56. extern void TimestampDifference(TimestampTz start_time, TimestampTz stop_time,
  57. long *secs, int *microsecs);
  58. extern bool TimestampDifferenceExceeds(TimestampTz start_time,
  59. TimestampTz stop_time,
  60. int msec);
  61. extern TimestampTz time_t_to_timestamptz(pg_time_t tm);
  62. extern pg_time_t timestamptz_to_time_t(TimestampTz t);
  63. extern const char *timestamptz_to_str(TimestampTz t);
  64. extern int tm2timestamp(struct pg_tm *tm, fsec_t fsec, int *tzp, Timestamp *dt);
  65. extern int timestamp2tm(Timestamp dt, int *tzp, struct pg_tm *tm,
  66. fsec_t *fsec, const char **tzn, pg_tz *attimezone);
  67. extern void dt2time(Timestamp dt, int *hour, int *min, int *sec, fsec_t *fsec);
  68. extern int interval2tm(Interval span, struct pg_tm *tm, fsec_t *fsec);
  69. extern int tm2interval(struct pg_tm *tm, fsec_t fsec, Interval *span);
  70. extern Timestamp SetEpochTimestamp(void);
  71. extern void GetEpochTime(struct pg_tm *tm);
  72. extern int timestamp_cmp_internal(Timestamp dt1, Timestamp dt2);
  73. /* timestamp comparison works for timestamptz also */
  74. #define timestamptz_cmp_internal(dt1,dt2) timestamp_cmp_internal(dt1, dt2)
  75. extern int isoweek2j(int year, int week);
  76. extern void isoweek2date(int woy, int *year, int *mon, int *mday);
  77. extern void isoweekdate2date(int isoweek, int wday, int *year, int *mon, int *mday);
  78. extern int date2isoweek(int year, int mon, int mday);
  79. extern int date2isoyear(int year, int mon, int mday);
  80. extern int date2isoyearday(int year, int mon, int mday);
  81. extern bool TimestampTimestampTzRequiresRewrite(void);
  82. #endif /* TIMESTAMP_H */
上海开阖软件有限公司 沪ICP备12045867号-1