Re: INSERT date format

Article View: borland.public.interbase.sql

Article #969

Back to borland.public.interbase.sql Previous Next

#969

From: Patrick Moloney
Date: Mon, 02 Apr 2007 16:09

26 lines
1578 bytes

aleplgr wrote:

> 
> 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);
Is that error coming from Interbase or your application? What
application are you typing this into - IBConsole?
How are the dates that are in there displayed? Put in a date that won't
reject like 1/12/2007. See how it gets displayed.


-- 
Patrick Moloney

Technical Details

Message-ID: <46111c8e$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!feeder3.cambrium.nl!feed.tweaknews.nl!newsfeed.kamp.net!newsfeed.kamp.net!newsfeed.freenet.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

References: <4610e304$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,cf151f5501431f39
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Patrick Moloney" <NewsID*at*SandrockSoftware.c*o*m>
Subject: Re: INSERT date format
Newsgroups: borland.public.interbase.sql
Reply-To: "Patrick Moloney" <NewsID@SandrockSoftware.com>
References:  <4610e304$1@newsgroups.borland.com>
User-Agent: XanaNews/1.18.1.3
NNTP-Posting-Host: 151.204.132.253
Message-ID: <46111c8e$1@newsgroups.borland.com>
Date: 2 Apr 2007 08:09:02 -0800
X-Trace: newsgroups.borland.com 1175526542 151.204.132.253 (2 Apr 2007 08:09:02 -0800)
Lines: 26
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!feeder3.cambrium.nl!feed.tweaknews.nl!newsfeed.kamp.net!newsfeed.kamp.net!newsfeed.freenet.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

Reply to Parent Message