| From: | Ben Primrose <bprimrose(at)tracelink(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Extract giving wrong week of year |
| Date: | 2015-09-25 20:54:28 |
| Message-ID: | df5f54d230b61e4d6a3c9161c3f7ca06@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
All,
I’m seeing some odd behavior from the extract function.
Any idea why extract would think January 3rd of next year is the 53rd week
of the year?
Thanks
Ben
[bprimrose(at)primrose partitioning]$ psql
Null display is "¤".
Line style is unicode.
Output format is wrapped.
Timing is on.
psql (9.3.9)
Type "help" for help.
bprimrose(at)home=> select extract (week from '2016-01-03
00:01:00'::timestamp);
date_part
───────────
53
(1 row)
Time: 1.128 ms
bprimrose(at)home=> select version();
version
─────────────────────────────────────────────────────────────────────────────────────────────────────────────
PostgreSQL 9.3.9 on x86_64-redhat-linux-gnu, compiled by gcc (GCC) 4.9.2
20150212 (Red Hat 4.9.2-6), 64-bit
(1 row)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2015-09-25 21:01:17 | Re: Extract giving wrong week of year |
| Previous Message | Raymond Brinzer | 2015-09-25 18:23:02 | Re: Automatically Updatable Foreign Key Views |