From: | John McKown <john(dot)archie(dot)mckown(at)gmail(dot)com> |
---|---|
To: | Jasim Mohd <hello(at)jasimmk(dot)com> |
Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Postgres RFC3339 datetime formatting |
Date: | 2016-05-10 16:43:53 |
Message-ID: | CAAJSdjjW2fMkHk5RW9PkGsqyUnARw4L6Bs45m=Xh=+joEQu5SQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Cheat?
# select translate(to_char(current_timestamp, 'YYYY-MM-DD HH:MI:SS.MSOF'),'
','T');
translate
----------------------------
2016-05-10T11:42:20.479-05
(1 row)
Just translate the blank in the result of to_char() to a T.
On Sun, May 8, 2016 at 3:59 AM, Jasim Mohd <hello(at)jasimmk(dot)com> wrote:
> Is there any way to format datetime to RFC3339Nano Eg:
> 2006-01-02T15:04:05.999999999Z07:00 in postgres 9.3 or 9.5?
>
> I tried with to_char. But there is no documentation how to handle T, Z,
> +07:00, -07:00 etc.
>
> The nearest one I can reach is
>
> v2=# select to_char(current_timestamp, 'YYYY-MM-DD HH:MI:SS.MSOF');
> to_char----------------------------
> 2016-05-08 12:16:14.493+04
>
> Which is default JSON output format datetime in postgres 9.3. Please see
> below.
>
> psql (9.5.1, server 9.3.6)
> Type "help" for help.
>
> fetchrdb=> select to_json(current_timestamp);
> to_json---------------------------------
> "2016-05-08 11:58:04.844548+04"(1 row)
>
> In the case of JSON encoded output from postgres 9.5 is RFC3339Nano eg:
>
> psql (9.5.1)
> Type "help" for help.
>
> v2=# select to_json(current_timestamp);
> to_json------------------------------------
> "2016-05-08T11:59:17.121411+04:00"
>
> I could't find an option to format datetime to RFC3339Nano in postgres 9.3
> or 9.5 using to_char.
>
> http://www.postgresql.org/docs/9.5/static/functions-formatting.html
>
> Is there any hidden option/functions you use to achieve the same? Any help
> regarding is appreciated.
>
> --
> Thanks & Regards
> skype: jasim.mk
>
--
The unfacts, did we have them, are too imprecisely few to warrant our
certitude.
Maranatha! <><
John McKown
From | Date | Subject | |
---|---|---|---|
Next Message | Igor Neyman | 2016-05-10 16:50:04 | Re: Increased I/O / Writes |
Previous Message | Albe Laurenz | 2016-05-10 16:29:22 | Re: Postgres RFC3339 datetime formatting |