CRM On Demand - Administration (MOSC)

MOSC Banner

How to use the TIMESTAMPADD function

edited Jul 26, 2011 8:00PM in CRM On Demand - Administration (MOSC) 11 commentsAnswered ✓
Hi,I need the following:
FieldA = FieldB + FIeldC

where: FieldA = Date field
             FieldB = Date Field
             FieldC = Numeric Field.

I understand that the TIMESTAMPADD function works for this, but I cant get this to work. I am trying to use it in the Defautl field value on FIeldA.

TIMESTAMPADD(SQL_TSI_DAY, "FIELDC", TIMESTAMP 'FIELDB')

How can I do this?

Thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center