I need to make an object current date,current week id and current week of year in the universe … could you help me with the function to extract current date, current week no. etc from current date. BO_USER1 (BOB member since 2011-03-27)

Objects in Universe

system June 21, 2011, 6:11am 2

Try the following link for the comprehensive usage of date/time oracle function

Credits to Gino!!

jprasanthram (BOB member since 2010-12-10)