Re: [libdbi-devel] libDBI (or ) pgsql driver: question on "timestamp"

[Toby T. <to...@te...>]

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
>