At 07:43 PM 2/2/2003 -0700, you wrote:
>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).
Yes, that was the exact text of the error message, but the extra spacing
was probably due to the copy/paste. The ".581084" is part of the data, and
apparently the culprit.
When I remove the DateFormat() calls the page runs fine. The date output
without the DateFormat is:
2003-02-02 21:08:37.942944
No extra spaces, but note the precision (sheesh... is that nanoseconds?) to
which the db is returning the time. This is what I think is different.
On a hunch, I compiled and installed the latest pgODBC driver, and the same
error occurred.
The field is data type "timestamp without time zone" (created from a script
as just "timestamp") on both servers. version() on the Windows server returns:
PostgreSQL 7.3.1 on i686-pc-cygwin, compiled by GCC gcc (GCC) 3.2
20020927 (pre release)
on my RedHat 7.2 server, I get:
PostgreSQL 7.3.1 on i686-pc-linux-gnu, compiled by GCC 2.96
Nothing odd there.
-B
>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
