Subject Re: [ib-support] Extract & SP
Author Burak OZLER

Should I procedure that converts the date in dd/mm/yyyy to mm/dd/yyyy or
CAST( Variable as DATE) 'll be enough for the operation

Thanks for your very valuable help...


----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <>
Sent: Wednesday, November 21, 2001 4:43 PM
Subject: Re: [ib-support] Extract & SP

> At 04:03 PM 21-11-01 +0200, you wrote:
> >Hi all
> > I call my SP from an other SP with this statement
> >"select CAOLDU from cari_ay_addupdate
> >
> >I get this
> >
> >"Overflow occurred during data type conversion.
> >conversion error from string "18/11/2001"."
> >
> >by the way the value that is made error is CHTARIH's value and its date
datatype not string must I convert the field or change the format ?
> Firebird is very fussy about the format of date literals. Only mm/dd/yyyy
is recognised as a slash-separated date. In this case the overflow occurred
because there are not 18 months in a year. (Actually, I don't believe there
are 12 months, either, because December comes around much too fast.)
> Use '' or 'dd-MMM-yyyy' (where MMM is English language month
abbreviations JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC) or
> With Dialect 3, you may find also that you need to use CAST with your date
literals in some places in your procedure, to correctly cast them as DATE or
> cheers,
> Helen
> All for Open and Open for All
> InterBase Developer Initiative ยท
> _______________________________________________________
> To unsubscribe from this group, send an email to:
> Your use of Yahoo! Groups is subject to