> I'm using oracle and when I try to disply time using > timeformat > (#timeformat(date1,"HH:mm:ss")#) from one of the date > field, it returns > 0:00:00, why was that? > Any advise?
if it's a "date" column, then the data type doesn't store time information which is why you get 00:00:00 as the time -- because there isn't any time in the database... If it's a "datetime" or a "timestamp" then I'm not sure what the problem would be. s. isaac dealey 972-490-6624 team macromedia volunteer http://www.macromedia.com/go/team chief architect, tapestry cms http://products.turnkey.to onTap is open source http://www.turnkey.to/ontap ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
