Helen;

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

Thanks for your very valuable help...

Burak

----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <ib-support@yahoogroups.com>
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
(:CHCARIID,:CHTARIH,:CHBORC,:CHTUTAR) into :OOLDUU;"
> >
> >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 'dd.mm.yyy' or 'dd-MMM-yyyy' (where MMM is English language month
abbreviations JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC) or
'yyyymmdd'.
>
> 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
TIMESTAMP.
>
> cheers,
> Helen
>
> All for Open and Open for All
> InterBase Developer Initiative · http://www.interbase2000.org
> _______________________________________________________
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>