Hello, François Hervieux wrote:
> 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. Please let us know if this helped. Regards, -- Maciej Sobczak * www.msobczak.com * www.inspirel.com ------------------------------------------------------------------------------ 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
