|
From: Toby T. <to...@te...> - 2011-04-26 00:10:05
|
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). --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 > lib...@li... > https://lists.sourceforge.net/lists/listinfo/libdbi-devel > |