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?
--------------------------------------------------------------------------- "Pharmaniaga Berhad, your integrated healthcare provider" www.pharmaniaga.com "Pharmaniaga Solutions... placing technology in the heart of your business and information in the palm of your hands" The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential or privileged material. If you received this in error, please contact the sender and delete the material from any computer. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. --------------------------------------------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm

