You are absoletely correct, quoting the zero did the trick...
And my database has been intialized with Norwegian local, so I am
guessing that that's reason
Thanks to all fo you... :)
BTJ
On Thu, 2003-09-11 at 16:26, Tom Lane wrote:
> =?ISO-8859-1?Q?Bj=F8rn?= T Johansen <[EMAIL PROTECTED]>
n" <[EMAIL PROTECTED]>
> > > Yes, I am sure, I just use copy-and-paste and I have double checked
> > > I am running on 7.3.4 but that shouldn't make any difference?
> > >
> > > BTJ
> > >
> > > On Thu, 2003-09-11 at 14
quot;Mattias Kregert" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, September 11, 2003 3:02 PM
Subject: Re: [GENERAL] I need a SQL...
> Well, it's close... :)
>
> But it looks like the case doesn't work..
> If I run your sql, the timediff is neg
> I am running on 7.3.4 but that shouldn't make any difference?
> >
> > BTJ
> >
> > On Thu, 2003-09-11 at 14:56, Mattias Kregert wrote:
> > > When i run it, it works as intended (on pg 7.3.3). Which version do you use?
> > >
> > >
I need to write a SQL that calculates the interval between a start time and a stop time. This is the easy part. The problem is that I only have the time part, i.e. no date, so how can I be sure to also calculate the interval if the start time is before midnight and the stop time is after midnig
On 11 Sep 2003, Bjørn T Johansen wrote:
> Yes, I am sure, I just use copy-and-paste and I have double checked
> I am running on 7.3.4 but that shouldn't make any difference?
>
> BTJ
>
> On Thu, 2003-09-11 at 14:56, Mattias Kregert wrote:
> > When i run it, it works as intended (on pg 7.3.3
lt;[EMAIL PROTECTED]>
> Sent: Thursday, September 11, 2003 3:02 PM
> Subject: Re: [GENERAL] I need a SQL...
>
>
> > Well, it's close... :)
> >
> > But it looks like the case doesn't work..
> > If I run your sql, the timediff is negative.
> >
gt; - Original Message -
> From: Bjørn T Johansen
> To: Andrew L. Gould
> Cc: PostgreSQL general list
> Sent: Thursday, September 11, 2003 2:12 PM
> Subject: Re: [GENERAL] I need a SQL...
>
> On Thu, 2003-09-1
dsfdfd
- Original Message -
From:
Bjørn T Johansen
To: Andrew L. Gould
Cc: PostgreSQL general list
Sent: Thursday, September 11, 2003 2:12
PM
Subject: Re: [GENERAL] I need a
SQL...
On Thu,
2003-09-11 at 14:07, Andrew L. Gould wrote:
Yes, the
On Thu, 2003-09-11 at 14:07, Andrew L. Gould wrote:
On Thursday 11 September 2003 06:25 am, Bjørn T Johansen wrote:
> I need to write a SQL that calculates the interval between a start time
> and a stop time. This is the easy part. The problem is that I only have
> the time part, i.e. no date,
On Thursday 11 September 2003 06:25 am, Bjørn T Johansen wrote:
> I need to write a SQL that calculates the interval between a start time
> and a stop time. This is the easy part. The problem is that I only have
> the time part, i.e. no date, so how can I be sure to also calculate the
> interval if
11 matches
Mail list logo
