Re: F_MAXDATE()

Article View: borland.public.interbase.sql

Article #594

Back to borland.public.interbase.sql Previous Next

#594

From: MrT
Date: Wed, 08 Aug 2007 18:10

29 lines
1531 bytes

MrT wrote:

Done.

  Hi:
       , CAST(CAST(F_MAXDATE(F_MAXDATE( m3."CRDRPT_RNW"
                 , m2."CRDRPT_RNW" )
                 , m4."CRDRPT_RNW" ) AS DATE) AS VARCHAR(250)) AS "CR Renew"





>   Why would
> 
> F_MAXDATE(F_MAXDATE(m2."CRDRPT_RNW", m3."CRDRPT_RNW"),m4."CRDRPT_RNW")
> 
> Be Ok in query run through IBConsole but fail in stored procedure with 
> message:
> 
> Arithmentic exception, numeric overflow or string truncation?
> 
> If I CAST(F_MAXDATE(F_MAXDATE(m2."CRDRPT_RNW", 
> m3."CRDRPT_RNW"),m4."CRDRPT_RNW") AS VARCHAR(10)) in the query inIB 
> Console I then get the same arithmetic overflow ....... error.
> 
> Suggestions?
> 
> Thanks.

Technical Details

Message-ID: <46b9f8e5@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <46b8a896$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,537ddb32d53edf11
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Wed, 08 Aug 2007 13:10:42 -0500
From: MrT <contact@heat-mi.org>
User-Agent: Thunderbird 1.5.0.12 (Windows/20070509)
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: Re: F_MAXDATE()
References: <46b8a896$1@newsgroups.borland.com>
In-Reply-To: <46b8a896$1@newsgroups.borland.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 69.39.70.127
Message-ID: <46b9f8e5@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1186592997 69.39.70.127 (8 Aug 2007 10:09:57 -0700)
Lines: 29
Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message