Drop a field onto report surface and go to property Inspector window (default F4). Look for properties named Source and set it to Current Date. Next provide format mask as follows: MON-DD-RRRR HH24:MI:SS (or whenever you want). Alternatively you can use
If you want to use formula column then
function F_1FormatTrigger return Char is
Return TO_CHAR(SYSDATE,'MON-DD-RRRR HH24:MI:SS');
if you do not want to use the formula column, then
set source of the field to "Current date". and set the format mask to "DD/MM/RRRR HH24:MI:SS".
Edited by: Alok Dubey on Jan 8, 2013 5:42 PM