Timestamp and the fractions of a second

Thread View: borland.public.interbase.opensource

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Gara Tue, 08 Nov 2005 12:07

#188

Author: 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
);

Re: Timestamp and the fractions of a second

#189

Author: Craig Stuntz TeamB
Date: Tue, 08 Nov 2005 13:37

14 lines
1547 bytes

Gara wrote:

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

	Neither, really. IB does not have the feature of full support for
milliseconds in a timestamp. There are historical reasons for this, and
there's a QC request open to add the feature, but for the time being
you really have to store milliseconds in a different way.

-- 
Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH
  Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
All the great TeamB service you've come to expect plus (New!) 
  Irish Tin Whistle tips: http://learningtowhistle.blogspot.com

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads