pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedODBC (6.40.0006): SQL_TIME binary format (bug? feature?)
2+ messages / 2 participants
[nested] [flat]
* ODBC (6.40.0006): SQL_TIME binary format (bug? feature?)
@ 1999-08-12 07:01 Gene Sokolov <hook@aktrad.ru>
0 siblings, 1 reply; 2+ messages in thread
From: Gene Sokolov @ 1999-08-12 07:01 UTC (permalink / raw)
To: pgsql-interfaces@hub.org
I have a table (PGSQL 6.5.0):
CREATE TABLE TimePeriods (
ID SERIAL PRIMARY KEY ,
MarketID INT NOT NULL REFERENCES Markets ,
WeekDay INT NOT NULL , /* 1-7, Sun-Mon */
TimeOpen TIME NOT NULL ,
TimeClose TIME NOT NULL
);
I do (WinNT 4.0 sp 4, ODBC v. 6.40.0006)
select * from timeperiods
The TimeOpen and TimeClose are stored as 4 byte values in the database. But
the ODBC driver returns them as 8 byte values in a completely unexpected
format! The usual binary representation of an SQL_TIME is (high to low) 1
byte hours, 1 byte minutes, 1 byte seconds and the lowest byte 1/100s of a
second.
Here I get (low to high): int16 hours, int16 minutes, int16 seconds, and
int16 0xCDCD. The result - 1/100s are lost and a lot of wasted network
bandwidth. What is the point of formatting TIME like that? Why does it clip
fractions of a second? Is it a bug or a feature? If it's a bug, how can I
help fixing it? If it's a feature, why is it needed?
Gene Sokolov.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [INTERFACES] ODBC (6.40.0006): SQL_TIME binary format (bug? feature?)
@ 1999-08-14 05:25 Thomas Lockhart <lockhart@alumni.caltech.edu>
parent: Gene Sokolov <hook@aktrad.ru>
0 siblings, 0 replies; 2+ messages in thread
From: Thomas Lockhart @ 1999-08-14 05:25 UTC (permalink / raw)
To: Gene Sokolov <hook@aktrad.ru>; +Cc: pgsql-interfaces@hub.org
> I have a table (PGSQL 6.5.0):
> CREATE TABLE TimePeriods (
> ID SERIAL PRIMARY KEY ,
> MarketID INT NOT NULL REFERENCES Markets ,
> WeekDay INT NOT NULL , /* 1-7, Sun-Mon */
> TimeOpen TIME NOT NULL ,
> TimeClose TIME NOT NULL
> );
> The TimeOpen and TimeClose are stored as 4 byte values in the database.
?? The TIME type is stored internally as a double precision float
afaik.
> the ODBC driver returns them as 8 byte values in a completely unexpected
> format! The usual binary representation of an SQL_TIME is (high to low) 1
> byte hours, 1 byte minutes, 1 byte seconds and the lowest byte 1/100s of a
> second.
Usual where?
> Here I get (low to high): int16 hours, int16 minutes, int16 seconds, and
> int16 0xCDCD. The result - 1/100s are lost and a lot of wasted network
> bandwidth. What is the point of formatting TIME like that? Why does it clip
> fractions of a second? Is it a bug or a feature? If it's a bug, how can I
> help fixing it? If it's a feature, why is it needed?
I'm not sure where int16 is coming from. Is it the case that the ODBC
driver must return TIME fields in this format? You seem to think not,
so without looking at the code I have no explanation.
- Thomas
--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1999-08-14 05:25 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-08-12 07:01 ODBC (6.40.0006): SQL_TIME binary format (bug? feature?) Gene Sokolov <hook@aktrad.ru>
1999-08-14 05:25 ` Thomas Lockhart <lockhart@alumni.caltech.edu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox