Timestamp and the fractions of a second

Article View: borland.public.interbase.opensource

Article #188

Back to borland.public.interbase.opensource Previous Next

#188

From: Gara
Date: Tue, 08 Nov 2005 12:07

17 lines
1622 bytes

I'm using Interbase 6.0.2.0 on Win2000 Professional and I'm having difficulty getting the fractional part of a second to a timestamp type database field.

The manual states that the insert syntax YYYY-MM-DD HH:MM:SS:thou should work but when I try:

INSERT INTO "TBLTEST" ("STARTTIME", "ENDTIME") VALUES ('2005-03-02 02:02:02.1234', '03:03:03.1234');

the fractional part is left out. When I try to insert the fractional part manually using IBConsole, I get a warning saying that the ' is not a valid date and time'.

Is this a bug in IB6 or is my syntax incorrect?

//TEST TABLE METADATA
CREATE TABLE "TBLTEST" 
(
  "STARTTIME"	TIMESTAMP NOT NULL,
  "ENDTIME"	TIME NOT NULL
);

Technical Details

Message-ID: <4370a31b$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!newsfeed01.chello.at!newsfeed.utanet.at!reader.uucp.at!feeder02.uucp.at!newsfeed.uucp.at!news.uucp.at!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 106772,e6bb3eafe40b98bd,start
X-Google-Attributes: gid106772,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Gara" <muu_osoite@hotmail.com>
Sender: "Gara" <muu_osoite@hotmail.com>
Reply-To: "Gara" <muu_osoite@hotmail.com>
Subject: Timestamp and the fractions of a second
Newsgroups: borland.public.interbase.opensource
X-User-Info: 62.165.183.34     
NNTP-Posting-Host: 207.105.83.66
Message-ID: <4370a31b$1@newsgroups.borland.com>
Date: 8 Nov 2005 05:07:39 -0700
X-Trace: newsgroups.borland.com 1131455259 207.105.83.66 (8 Nov 2005 05:07:39 -0700)
Lines: 17
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!newsfeed01.chello.at!newsfeed.utanet.at!reader.uucp.at!feeder02.uucp.at!newsfeed.uucp.at!news.uucp.at!newsgroups.borland.com!not-for-mail