INSERT DATE type

Article View: borland.public.interbase.sql

Article #983

Back to borland.public.interbase.sql Previous Next

#983

From: aleplgr
Date: Wed, 04 Apr 2007 16:26

11 lines
1275 bytes

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

Technical Details

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

Path:

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

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,8417dee86f0635f8,start
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "aleplgr" <aleplgr@yahoo.es>
Sender: "aleplgr" <aleplgr@yahoo.es>
Reply-To: "aleplgr" <aleplgr@yahoo.es>
Subject: INSERT DATE type
Newsgroups: borland.public.interbase.sql
X-User-Info: 80.58.205.38     
X-Forwarded-For: 80.25.195.180, 192.168.1.66
NNTP-Posting-Host: 207.105.83.66
Message-ID: <4613c3ad$1@newsgroups.borland.com>
Date: 4 Apr 2007 08:26:37 -0800
X-Trace: newsgroups.borland.com 1175700397 207.105.83.66 (4 Apr 2007 08:26:37 -0800)
Lines: 12
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.germany.com!newsfeed.datemas.de!news.albasani.net!feeder06.uucp-net.de!reader.uucp.at!feeder08.uucp.at!feeder10.uucp.at!news.uucp.at!newsgroups.borland.com!not-for-mail