Contains a SQL statement to get the current date. It uses the following format:
select sys_extract_utc(current_timestamp ) from &Table_Owner.S_DUAL
To get the current date, this statement calls the following Siebel function: now
The SQL can include a math function. For example, the following SQL statement returns the current date plus seven days: select {fn now()}+7 from &Table_Owner.S_DUAL
Different RDBMS databases use different formats for the same function. For example, in MSSQL, the GetDate function returns the current date. The column name length must be less than 30 characters. For example, the following statement is not valid because it is more than 30 characters in length: TO_CHAR(CREATED,'dd month yyyy','NLS_DATE_LANGUAGE=FRENCH')
|