On 26/04/11 3:02 PM, Holger Hetterich wrote: > Am Montag, den 25.04.2011, 19:50 -0400 schrieb Toby Thain: >> On 25/04/11 5:47 PM, Holger Hetterich wrote: >>> Hi, >>> >>> In postgresql I store data of type "timestamp" such as: >>> "2011-04-17 12:58:51.074" >>> >>> While the database can handle this format, and for example correctly >>> sorts while taking care of the milliseconds, it looks to me it's >>> impossible to retrieve this data via libDBI. What I found was the >>> get_datetime functions, which return a time_t. Any way to get the >>> information about the milliseconds, _or_ get a string or binary >>> representation of what is stored in the DB, so that I can convert it >>> back to a string on the client side? >>> >> >> Indeed, a function to retrieve this as a string is needed. It's really >> an error for the library to treat it like a time_t; I think the MySQL >> DATE/TIME types come back as strings (but don't quote me; it's a long >> time since I used libdbi). > > libDBI is so cool, I think it's worth to extend libDBI with functions to > return DB data as a string representation in general. >
On this list, I've proposed something similar in the past (a "type-coercing" interface). It is even more important for integer types, as you see from your other posting recently on the list. (I think there should be an additional facility to fetch an integer without knowing the precise storage type; this facilitates database and schema independence.) In many cases strings are already returned for data types that have no natural C representation (DATE/TIME as I mentioned, DECIMAL, ENUM, and so on), so I consider your specific issue here more of a bug than a missing function (since the time_t conversion makes no sense - but I haven't checked the code to see what's going on). --Toby > I have time pressure on my current project, and getting the milliseconds > is not crucial, so I can forward now with a time_t. After that, I would > like to look deeper at libDBI and create patches to return any value as > a string representation. Would that be a good idea? > > Holger > > > >> >> --Toby >> >> >>> Or maybe I oversee a useful function to get to this information... >>> >>> Holger >>> >>> >>> >>> >>> ------------------------------------------------------------------------------ >>> WhatsUp Gold - Download Free Network Management Software >>> The most intuitive, comprehensive, and cost-effective network >>> management toolset available today. Delivers lowest initial >>> acquisition cost and overall TCO of any competing solution. >>> http://p.sf.net/sfu/whatsupgold-sd >>> _______________________________________________ >>> libdbi-devel mailing list >>> libdbi-devel@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/libdbi-devel >>> >> >> >> ------------------------------------------------------------------------------ >> WhatsUp Gold - Download Free Network Management Software >> The most intuitive, comprehensive, and cost-effective network >> management toolset available today. Delivers lowest initial >> acquisition cost and overall TCO of any competing solution. >> http://p.sf.net/sfu/whatsupgold-sd >> _______________________________________________ >> libdbi-devel mailing list >> libdbi-devel@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/libdbi-devel > > > > ------------------------------------------------------------------------------ > WhatsUp Gold - Download Free Network Management Software > The most intuitive, comprehensive, and cost-effective network > management toolset available today. Delivers lowest initial > acquisition cost and overall TCO of any competing solution. > http://p.sf.net/sfu/whatsupgold-sd > _______________________________________________ > libdbi-devel mailing list > libdbi-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/libdbi-devel > ------------------------------------------------------------------------------ WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd _______________________________________________ libdbi-devel mailing list libdbi-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libdbi-devel
