| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | John R Pierce <pierce(at)hogranch(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: About the MONEY type |
| Date: | 2016-12-17 23:25:56 |
| Message-ID: | 20161217232556.GA19811@momjian.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Nov 30, 2016 at 01:35:12PM -0800, John R Pierce wrote:
> note, btw, TIMESTAMP WITH TIME ZONE doesn't actually store the timezone...
> rather, it converts it to an internal representation of GMT, and then converts
> it back to display time at the client's current (or specified) time zone.
Right, TIMESTAMP WITH TIME ZONE converts the timestamp value to the
local time zone on output. Imagine a monetary type that converted the
money amount to local currency on output --- that would be cool.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | rich | 2016-12-18 17:40:33 | Postgres 9.6 Streaming Replication on Solaris 10 |
| Previous Message | guyren | 2016-12-17 22:57:51 | Love Your Database: Simple Validations |