I was thinking that it may be a timezone thing. Some of the dates are of
CDT and some are CST.
I live in Dallas which is the Central Time Zone.
I just don't understand. I seem to have alot of time/date problems with
Postgres. Maybe its just me.
Actually, now I see what is going on. I define
It's not a timezone problem is it? Did the dates get re-loaded
correctly?
Andy Lewis wrote:
>
> I have 2 tables both of which have a datetime field and both have an
> identifier of date_submitted.
>
> I've been using(via PHP) a query of the following for a month or so with
> no problem:
>
> se
I have 2 tables both of which have a datetime field and both have an
identifier of date_submitted.
I've been using(via PHP) a query of the following for a month or so with
no problem:
select count(*) from mytable1 where date_submitted > 'today'::datetime
and
select count(*) from mytable2 where
