On Thu, Oct 02, 2003 at 10:04:39AM -0400, Tom Lane wrote:
> Karel Zak <[EMAIL PROTECTED]> writes:
> > The to_timestamp() do nothing with date/time and use internal
> > tm2timestamp() routine only. I don't think that check all date/time
> > ranges in to_timestamp() is good idea if it's already
Karel Zak <[EMAIL PROTECTED]> writes:
> The to_timestamp() do nothing with date/time and use internal
> tm2timestamp() routine only. I don't think that check all date/time
> ranges in to_timestamp() is good idea if it's already implemented at
> the another place in our code.
But it evidently
On Wed, Oct 01, 2003 at 07:57:18PM -0700, Theodore Petrosky wrote:
> here is the actual query:
>
> agencysacks=# SELECT jobnumseq, (SELECT cname FROM
> clientinfo ci WHERE ci.acode = j.clientid) as client,
> shrtdesc, to_char(proofduedate, 'Dy FMMon DD,
> HH12 am') FROM jobs j WHERE proof
So really if I had started coding this in a month
other than September I would have seen the problem
sooner...
Thanks for the help
Ted
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Theodore Petrosky <[EMAIL PROTECTED]> writes:
> > I should have sent this... it is very
> interesting..
> > agencys
On Wed, Oct 01, 2003 at 11:38:55PM -0400, Tom Lane wrote:
> Theodore Petrosky <[EMAIL PROTECTED]> writes:
> > I should have sent this... it is very interesting..
> > agencysacks=# select to_timestamp('01 October 2003
> > 00:01', 'DD Month HH24:MI');
> > to_timestamp
> > --
Theodore Petrosky <[EMAIL PROTECTED]> writes:
> I should have sent this... it is very interesting..
> agencysacks=# select to_timestamp('01 October 2003
> 00:01', 'DD Month HH24:MI');
> to_timestamp
> -
> 0003-10-01 00:01:00
> (1 row)
Oh ... duh ... you should ha
I like this one:
agencysacks=# select to_timestamp('31 September 2003
23:59', 'DD Month HH24:MI');
to_timestamp
2003-10-01 23:59:00-04
(1 row)
agencysacks=# select to_timestamp('32 September 2003
23:59', 'DD Month HH24:MI');
to_timestamp
I should have sent this... it is very interesting..
agencysacks=# select to_timestamp('01 October 2003
00:01', 'DD Month HH24:MI');
to_timestamp
-
0003-10-01 00:01:00
(1 row)
agencysacks=# select to_timestamp('01 October 2003
23:59', 'DD Month HH24:MI');
here is the actual query:
agencysacks=# SELECT jobnumseq, (SELECT cname FROM
clientinfo ci WHERE ci.acode = j.clientid) as client,
shrtdesc, to_char(proofduedate, 'Dy FMMon DD,
HH12 am') FROM jobs j WHERE proofduedate BETWEEN
to_timestamp('01 October 2003 00:01', 'DD Month
HH24:MI')
Theodore Petrosky <[EMAIL PROTECTED]> writes:
> I am sorry, I wasn't clear... when i refered to
> 01 October 2003
> I got zero results. I only got results for the October
> 1 date when i refered to it as september 31
That's a bit hard to believe. Could you show us the results of the
individu
I am sorry, I wasn't clear... when i refered to
01 October 2003
I got zero results. I only got results for the October
1 date when i refered to it as september 31
I am on 7.3.4 on OS X
Ted
--- Bruno Wolff III <[EMAIL PROTECTED]> wrote:
> On Wed, Oct 01, 2003 at 10:26:57 -0700,
> Theodor
On Wed, Oct 01, 2003 at 10:26:57 -0700,
Theodore Petrosky <[EMAIL PROTECTED]> wrote:
> I am not sure but i thought I read something of this
> problem and maybe its not a problem but my
> understanding.
>
> There are only 30 days in september however I can not
> seem to make a query that asks for
I am not sure but i thought I read something of this
problem and maybe its not a problem but my
understanding.
There are only 30 days in september however I can not
seem to make a query that asks for october 1.
proofduedate is time stamp with zone
maybe this is the problem but I am a little los
13 matches
Mail list logo
