Hi Everybody,
I have a table with a column of timestamp type. It is
known to postgres like this:
name | character varying | not null
value | character varying | not null
datecreated | timestamp without time zone | not null
when I do query
select name, value, datecreated
from mytable
where datecreated > 2007-10-02;
it reports:
name | value | datecreated
----------+----------------------+-------------------------
al_qual | 0 | 2007-08-09 00:06:06.742
srehquan | 3 | 2007-08-09 00:06:06.742
complete | 1 | 2007-08-09 00:06:06.743
al_quan | 0.315924933 | 2007-08-09 00:06:06.742
bsa_qual | 0 | 2007-08-09 00:06:06.743
bsl_qual | 2 | 2007-08-09 00:06:06.743
sh_qual | 0 | 2007-08-09 00:06:06.742
. . . .
. . . .
I don't understand why it thinks August is greater than
October. Can someone please elucidate what is going on?
Regards,
Tena Sakai
[EMAIL PROTECTED]
