>
> > I'm trying to fetch some data typed "time without time zone" from a
> > Postgresql database but I can't get it to work.
>
> The time type contains only the time of the day, whereas SOCI was
> prepared to work with datetimes that include both date and time components.
>
> As a dirty trick you might try to modify your query so that it provides
> the "missing" date part in the time column:
>
> select name, current_date || ' ' || value from time_variables
>
> (with appropriate quoting if necessary)
>
> This should produce the value that is understandable by the internal
> SOCI parser.
>
Thanks for your reply.
When I concatenate current_date, the value is treated as a std::string by
SOCI. There isn't an exception anymore but I have to parse it in order to
get a std::tm. Is there a way to get directly a binary value ?
--
François Hervieux
[email protected]
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users
