Forum Stats

  • 3,826,280 Users
  • 2,260,619 Discussions
  • 7,896,865 Comments

Discussions

Retrieiving time from Portal Custom Date Attribute via PLSQL

577523
577523 Member Posts: 1
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
Tagged:
This discussion has been closed.