Retrieiving time from Portal Custom Date Attribute via PLSQL

577523

I have a custom Attribute based on the Date Datatype that accepts a date/time combination for a custom calendar application. The problem is that when I attempt to retrieve the value from the wwsbr_Item_Attributes, the value only contains the Date part.

Update: Digging deeper if I look at WWUTL_SBR_TX_THINGATTRIBUTES$ or WWV_THINGATTRIBUTES It does contain a time but is always 12:00. If I view the original item via the portal interface, I can in fact get the time from it? What is going on here?

Anyone have any thoughts on how to get around this? should I only be looking at a different view or table?

Thanks,
Jeff

Edited by: Jeff98 on May 26, 2009 9:37 AM