Thread: What is it?
Hello All! What is it? traffic=# select extract(day from date('23-03-2001')); date_part ----------- 23 (1 row) traffic=# select extract(day from date('24-03-2001')); date_part ----------- 24 (1 row) traffic=# select extract(day from date('25-03-2001')); date_part ----------- 24 (1 row) traffic=# select extract(day from date('26-03-2001')); date_part ----------- 26 (1 row) Debian GNU/Linux, Kernel 2.2.18 PostgreSQL 7.02 With best wishes Victor Vislobokov Perm, Russia
"Victor Vislobokov" <victor@tvmaxima.perm.ru> writes: > Hello All! > > What is it? Hmmm, my results - test=# select extract(day from date('23-03-2001')); date_part ----------- 23 (1 row) test=# select extract(day from date('24-03-2001')); date_part ----------- 24 (1 row) test=# select extract(day from date('25-03-2001')); date_part ----------- 25 (1 row) test=# select extract(day from date('26-03-2001')); date_part ----------- 26 (1 row) Linux 2.2.18pre21, postgresql 7.1beta6 -- Pete Jewell Example Systems Ltd. -------------------- The views expressed in this email are not necessarily those of Example Systems Ltd unless explicitly stated.