Does it return 2003-01-23 17:18:15.581084 exactly? Cuz it should be like this:
2003-01-23 17:18:15 meaning you have .581084 on the end there. And you have some an extra space in there as well. Maybe that's your problem. Go in and edit a record (remove that from the end) and see if it works (query for that record only). At 09:29 PM 2/2/03 -0500, you wrote: >Hey all... anyone using PostgreSQL 7.3.1 with CF 5? I upgraded my DB server >and I'm getting the strangest CF error: > > "Parameter 1 of function DateFormat which is now >"2003-01-23 17:18:15.581084" must be a date/time value" > >This code works on CF 5 for Windows + PG 7.3.1 via Cygwin, so my guess is >it has something to do with the ODBC drivers. Did the precision of >timestamp fields change with 7.3? > >-B > > > > >_____ >Brian Panulla [EMAIL PROTECTED] >Chief Information Officer 814.867.4087 >Elmwood Media Group www.elmwoodmedia.com > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=14 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=14 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14
