INSERT date format

Article View: borland.public.interbase.sql

Article #966

Back to borland.public.interbase.sql Previous Next

#966

From: aleplgr
Date: Mon, 02 Apr 2007 12:03

24 lines
1546 bytes

Hi, I'm trying to insert a row:  

INSERT INTO TEMPORALPRUEBA1 (
  CLIENTID, DATE2, DATE1, GENE
) VALUES (
  1, '01/01/2007', '13/01/2007', GEN_ID(GENIDFECH,1) );

in this table:
CREATE TABLE TEMPORALPRUEBA1 (
  CLIENTID INTEGER,
  DATE2 DATE,
  DATE1 DATE,
  GENE INTEGER NOT NULL);
ALTER TABLE TEMPORALPRUEBA1 ADD CONSTRAINT INTEG_1199 PRIMARY KEY (GENE);

I get the error:
Overflow occurred during data type conversion.Conversion error from string "13/01/2007".

It is because it tries to insert '01/13/2007'

To insert 13/01/2007 I have to insert 01/13/2007 
When do you set that? In the environmental options the DATE is set to dd/MM/yyyy why does it insert in reverse order the day and the month? 
It's InterBase 7.5

Technical Details

Message-ID: <4610e304$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,cf151f5501431f39,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 format
Newsgroups: borland.public.interbase.sql
X-User-Info: 80.58.205.38     
X-Forwarded-For: 80.25.195.180, 192.168.1.55
NNTP-Posting-Host: 207.105.83.66
Message-ID: <4610e304$1@newsgroups.borland.com>
Date: 2 Apr 2007 04:03:32 -0800
X-Trace: newsgroups.borland.com 1175511812 207.105.83.66 (2 Apr 2007 04:03:32 -0800)
Lines: 26
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail