Andrew Clark wrote: > CF 7.0.2 Standard, PostgreSQL 8.2.5 > When going through ODBC cf_sql_timestamp is able to use functions that > have arguments of type 'timestamp without time zone', but when going > through JDBC cf_sql_timestamp requires the function argument type to be > 'timestamp with time zone'.
Which ODBC and JDBC driver are you using? Have you changed the prepare threshold for the JDBC driver? What do you get from the following three queries through JDBC and ODBC: SELECT CAST(<cfqueryparam value="#now()#" cfsqltype="cf_sql_timestamp"> AS TEXT); SELECT CAST( CAST(<cfqueryparam value="#now()#" cfsqltype="cf_sql_timestamp"> AS TIMESTAP WITH TIME ZONE) AS TEXT); SELECT CAST( CAST(<cfqueryparam value="#now()#" cfsqltype="cf_sql_timestamp"> AS TIMESTAP WITHOUT TIME ZONE) AS TEXT); Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289545 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
