<p><font size="2">Hi Everybody,<br /><br /> I have a table with a column of timestamp type. It is<br /> known to
postgreslike this:<br /><br /> name | character varying | not null<br /> value |
charactervarying | not null<br /> datecreated | timestamp without time zone | not null<br /><br /> when
Ido query<br /><br /> select name, value, datecreated<br /> from mytable<br /> where datecreated >
2007-10-02;<br/><br /> it reports:<br /><br /> name | value | datecreated <br />
----------+----------------------+-------------------------<br/> al_qual | 0 | 2007-08-09
00:06:06.742<br/> srehquan | 3 | 2007-08-09 00:06:06.742<br /> complete | 1 |
2007-08-0900:06:06.743<br /> al_quan | 0.315924933 | 2007-08-09 00:06:06.742<br /> bsa_qual |
0 | 2007-08-09 00:06:06.743<br /> bsl_qual | 2 | 2007-08-09 00:06:06.743<br />
sh_qual | 0 | 2007-08-09 00:06:06.742<br /> . . . .<br
/> . . . .<br /><br /> I don't understand why it thinks August is greater
than<br/> October. Can someone please elucidate what is going on?<br /><br /> Regards,<br /><br /> Tena Sakai<br />
tsakai@gallo.ucsf.edu<br/><br /></font>