select {fn now()} from &Table_Owner.S_DUAL
This statement calls the Siebel function now() to obtain the current date and uses the table &Table_Owner.S_DUAL to hold the value temporarily. The S_DUAL table is used to hold temporary values. Math functions can also be performed. For example, SQL Statement = select {fn now()}+7 from &Table_Owner.S_DUAL returns the current date plus seven days. Different RDBMS have different formats for the same function (for example, in MS SQL, the function GetDate() is used to return the current date). |