Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: OPENROWSET using ORACLE and DATEDIFF

Re: OPENROWSET using ORACLE and DATEDIFF

From: Andy <nospam_at_nospam.com>
Date: Tue, 15 Oct 2002 10:41:52 +0100
Message-ID: <3dabe2e0$0$1292$ed9e5944@reading.news.pipex.net>


Thanks Sybrand
Do I detect a subtle anti-microsoft undertone in your reply?! :o)

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:hdtlquc9kdasttndjonurpdhvkth5b2kct_at_4ax.com...
> On Mon, 14 Oct 2002 16:22:07 +0100, "Andy" <nospam_at_nospam.com> wrote:
>
> > FROM IGS.EVT_AGENT_ACTIVITY
> > WHERE DATEDIFF(''H'',TO_DATE(AA_TIME_STAMP,''yyyy/mm/dd:hh:mi:ss'') ,
> >TO_DATE(''2002/10/13:11:00:00'',''yyyy/mm/dd:hh:mi:ss''))<2
> > ')
>
> You are mixing Oracle-based function and Microsux functions.
> You need to either
> - rewrite the sql to use Oracle functions only (and run it as a
> passthrough query)
> -or rewrite the sql to use Microsux functions only.
>
> In Oracle the datediff function is not applicable, you just subtract
> two dates, in Microsux the to_date function doesn't exist.
>
> I would try to prevent using this group as a debugging tool.
>
> Regards
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Tue Oct 15 2002 - 04:41:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US