Hi, I have some code that currently formats an Oracle Date field as follows:
#TimeFormat(AVAILABLE_DATE_TIME,"h:mm tt")# #DateFormat(AVAILABLE_DATE_TIME,"dddd dd mmmm yyyy")# The database schema is changing and I've just received the new version, where the AVAILABLE_DATE_TIME column is now a "Timestamp(6) With Time Zone" data type. TimeFormat and DateFormat are now failing miserably on it with errors like: 2009-03-20 02:52:00.000000 ->3:B8 is an invalid date or time string. If I cfdump the AVAILABLE_DATE_TIME the output is like this: 2009-03-19 21:52:00.000000 ->3:B8 I'm using CF 8 with the bundled Oracle JDBC driver, and the database is Oracle Database 10g Release 10.2.0.4.0 - Production (running on Linux, as far as I can recall). Any ideas what's going on? Can CF work with this field, or am I going to have to use to_char or something else to format it via sql? Thanks, Andrew. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
