Обсуждение: 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.