VoyForums
[ Show ]
Support VoyForums
[ Shrink ]
VoyForums Announcement: Programming and providing support for this service has been a labor of love since 1997. We are one of the few services online who values our users' privacy, and have never sold your information. We have even fought hard to defend your privacy in legal cases; however, we've done it with almost no financial support -- paying out of pocket to continue providing the service. Due to the issues imposed on us by advertisers, we also stopped hosting most ads on the forums many years ago. We hope you appreciate our efforts.

Show your support by donating any amount. (Note: We are still technically a for-profit company, so your contribution is not tax-deductible.) PayPal Acct: Feedback:

Donate to VoyForums (PayPal):

Login ] [ Contact Forum Admin ] [ Main index ] [ Post a new message ] [ Search | Check update time | Archives: 1[2] ]
Subject: Verkefni 2 - liður 3


Author:
g
[ Next Thread | Previous Thread | Next Message | Previous Message ]
Date Posted: 16:56:08 02/Nov/2007

Ég er að lenda í smá vandræðum með
SELECT epg_getdata('tími', mínútur)

Hvernig nota ég þessi gildi inni í fallinu sem ég bý til ?
Ég fæ $1 og $2 ekki til að virka.

Er hægt að gera svona:
select asdf from qwerty
where s.airdatetime between $1 and $1 + interval '$2 minutes'

þannig að það virki eins og:
select asdf from qwerty
where s.airdatetime between timestamp '2005-07-01 22:15:00'
AND
timestamp '2005-07-01 22:15:00' + interval '120 minutes'

?

[ Next Thread | Previous Thread | Next Message | Previous Message ]

Replies:
Subject Author Date
Re: Verkefni 2 - liður 3g00:02:07 03/Nov/2007


[ Contact Forum Admin ]


Forum timezone: GMT+0
VF Version: 3.00b, ConfDB:
Before posting please read our privacy policy.
VoyForums(tm) is a Free Service from Voyager Info-Systems.
Copyright © 1998-2019 Voyager Info-Systems. All Rights Reserved.