CF Ent and CF Std servers are probably using different drivers or versions of the drivers to talk to the Oracle server. If TIMESTAMP works in both then just use it in both.
On 11/11/05, Casey C Cook <[EMAIL PROTECTED]> wrote: > > "CF_SQL_TIME is for temporal data (times), CF_SQL_DATE is for dates, > and CF_SQL_TIMESTAMP is for timestamps (datetimes). > > cheers, > barneyb" > > > Thanks for the reply, Im just at a loss as to why CF_SQL_TIME can be used > in one environment and it passes in the date/time correctly but in another > environment its only passing in the time and uses the date Jan 1, 1900. > For a fix I will be using the CF_SQL_TIMESTAMP but having two enviroments > act differently with the same code is throwing me off. > > Thanks, > CC > x56927 > > > > ---------------------------------------------------------------------------------------- > This is a PRIVATE message. If you are not the intended recipient, please > delete without copying and kindly advise us by e-mail of the mistake in > delivery. NOTE: Regardless of content, this e-mail shall not operate to > bind CSC to any order or other contract unless pursuant to explicit > written agreement or government initiative expressly permitting the use of > e-mail for such purpose. > > ---------------------------------------------------------------------------------------- > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223971 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
