Skip to content
Snippets Groups Projects
Select Git revision
  • benchmark-tools
  • postgres-lambda
  • master default
  • REL9_4_25
  • REL9_5_20
  • REL9_6_16
  • REL_10_11
  • REL_11_6
  • REL_12_1
  • REL_12_0
  • REL_12_RC1
  • REL_12_BETA4
  • REL9_4_24
  • REL9_5_19
  • REL9_6_15
  • REL_10_10
  • REL_11_5
  • REL_12_BETA3
  • REL9_4_23
  • REL9_5_18
  • REL9_6_14
  • REL_10_9
  • REL_11_4
23 results

datetime.c

Blame
    • Thomas G. Lockhart's avatar
      2cf16424
      Fix INTERVAL output when year/month has different sign as day/hour etc. · 2cf16424
      Thomas G. Lockhart authored
       Previously, all fields were unsigned, with only a trailing "ago" to
       indicate negative intervals. Now, ISO format does not use "ago", and
       and the traditional PostgreSQL format has the first numeric field unsigned
       with "ago" supporting that field. So "1 month - 2 days ago" is two days
       less than a month in the past.
      Fix interval arithmetic across daylight savings time boundaries.
       Previously, most math across boundaries introduced a one hour offset.
      Allow some date/time functions to return NULL if called with NULL args.
      Implement functions for AT TIME ZONE support.
      Support "SAT" as an Australian time zone if USE_AUSTRALIAN_RULES
       is defined.
      2cf16424
      History
      Fix INTERVAL output when year/month has different sign as day/hour etc.
      Thomas G. Lockhart authored
       Previously, all fields were unsigned, with only a trailing "ago" to
       indicate negative intervals. Now, ISO format does not use "ago", and
       and the traditional PostgreSQL format has the first numeric field unsigned
       with "ago" supporting that field. So "1 month - 2 days ago" is two days
       less than a month in the past.
      Fix interval arithmetic across daylight savings time boundaries.
       Previously, most math across boundaries introduced a one hour offset.
      Allow some date/time functions to return NULL if called with NULL args.
      Implement functions for AT TIME ZONE support.
      Support "SAT" as an Australian time zone if USE_AUSTRALIAN_RULES
       is defined.
    datetime.c 54.76 KiB