[transfer-dev] Re: Date precision Postgresql vs. Oracle

2010-08-27 Thread pedrobl
Hi Mark! On Aug 27, 1:29 am, Mark Mandel wrote: So this is just on retrieval, and just on list operations? On both. I've just tested it. I'm trying to display what comes from the list (myTimeStamp), or from the get() entry using: DateFormat(myTimeStamp,/MM/DD) TimeFormat(TimeStamp,

[transfer-dev] Re: Date precision Postgresql vs. Oracle

2010-08-27 Thread pedrobl
Oops! I meant: DateFormat(myTimeStamp,/MM/DD) TimeFormat(myTimeStamp, HH:mm:ss) Pedro. -- Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer Try out the new Transfer ORM Custom Google Search:

[transfer-dev] Re: Date precision Postgresql vs. Oracle

2010-08-27 Thread pedrobl
And also, the version for the coldfusion/drivers/ojdbc14.jar, from its MANIFEST file: Specification-Title:Oracle JDBC driver classes for use with JDK14 Created-By: 1.4.2_08 (Sun Microsystems Inc.) Implementation-Title: ojdbc14.jar Specification-Vendor: Oracle Corporation

[transfer-dev] Re: Date precision Postgresql vs. Oracle

2010-08-27 Thread pedrobl
Your question on jdbc Driver version was on the right track. I found a known problem with the jdbc drivers provided by adobe. Interesting discussion: http://www.justskins.com/forums/cfmx-and-oracle-10g-128214.html I'll see if I can convince IT to modify Coldfusion's bootup options. Another

[transfer-dev] Re: Date precision Postgresql vs. Oracle

2010-08-27 Thread pedrobl
I installed CF7 on the machine I have postgres, and it works just fine, it shows the date and time correctly. The problem is then with the oracle jdbc driver in coldfusion. I have also tried to change the field to timestamp in oracle. This provokes a JAVACast exception that I'll try to check on