Re: INSERT DATE type

Article View: borland.public.interbase.sql

Article #986

Back to borland.public.interbase.sql Previous Next

#986

From: Bill Todd
Date: Wed, 04 Apr 2007 17:00

22 lines
1728 bytes

aleplgr wrote:

> 
> Hi! I'm getting an overflow error for the MYDATE variable  in this
> instruction:   
> INSERT INTO TEMP (CLIENTID,MYDATE,FLAG) VALUES (:MYCLIENT,:MYDATE,1);
>  
>  
>  the debugger shows that it tries to insert doing this:
> INSERT INTO TEMP (CLIENTID,MYDATE,FLAG) VALUES (1,CAST ('01/13/2007'
> AS DATE),1); but the debugger also shows  MYDATE variable as
> 13/01/2007, why does it reverse the day and the month to insert?
> MYDATE type is DATE I'm in IB 7.5

There is no debugger for stored procs and triggers built into
InterBase. I assume you are using some third party tool that simulates
execution of the code and the third party debugger is in an infinitely
recursive loop. This is not an IB problem because IB is not being used
to debug the code.

-- 
Bill Todd (TeamB)

Technical Details

Message-ID: <4613cb93$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.germany.com!newsfeed.freenet.de!news.albasani.net!feeder06.uucp-net.de!reader.uucp.at!newsfeed.uucp.at!news.uucp.at!newsgroups.borland.com!not-for-mail

References: <4613c3ad$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,8417dee86f0635f8
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bill Todd" <no@no.com>
Subject: Re: INSERT DATE type
Newsgroups: borland.public.interbase.sql
References:  <4613c3ad$1@newsgroups.borland.com>
Organization: The Database Group, Inc.
User-Agent: XanaNews/1.18.1.6
X-Face: ":yn4zt^A_dn>6~{YJmu^B\'4w)e:apPM\VC=Dvf&*tASxX9|BYczkFd$xr.$vNSZ[3Uobr p]c4\+\l){!WQI.$]veP({HLd;CDYH?iN
NNTP-Posting-Host: 216.207.211.19
Message-ID: <4613cb93$1@newsgroups.borland.com>
Date: 4 Apr 2007 09:00:19 -0800
X-Trace: newsgroups.borland.com 1175702419 216.207.211.19 (4 Apr 2007 09:00:19 -0800)
Lines: 22
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.germany.com!newsfeed.freenet.de!news.albasani.net!feeder06.uucp-net.de!reader.uucp.at!newsfeed.uucp.at!news.uucp.at!newsgroups.borland.com!not-for-mail

Reply to Parent Message