Re: date_trunc() in a specific time zone - Mailing list pgsql-hackers

From Tom Lane
Subject Re: date_trunc() in a specific time zone
Date
Msg-id 8424.1540831996@sss.pgh.pa.us
Whole thread Raw
In response to Re: date_trunc() in a specific time zone  (Paul A Jungwirth <pj@illuminatedcomputing.com>)
Responses Re: date_trunc() in a specific time zone  (Paul A Jungwirth <pj@illuminatedcomputing.com>)
List pgsql-hackers
Paul A Jungwirth <pj@illuminatedcomputing.com> writes:
> It would be nice to support both timestamptz and timestamp, with the
> output matching whatever type you give as input. I know which to use
> is controversial, but plain timestamp is the default in Ruby on Rails,
> so people encounter it a lot.

We already have date_trunc() for timestamp-without-tz, so I'm a little
confused as to what you think is/would be missing.

            regards, tom lane


pgsql-hackers by date:

Previous
From: Paul A Jungwirth
Date:
Subject: Re: date_trunc() in a specific time zone
Next
From: Paul A Jungwirth
Date:
Subject: Re: date_trunc() in a specific time zone