| Subject | date conversion issue | 
|---|---|
| Author | d_dude_2003 | 
| Post date | 2007-02-11T13:45:36Z | 
I have the following statement
DELETE FROM HRM_ATTENDANCERAW
WHERE HRM_ATTENDANCERAW.ADATE < CURRENT_DATE - :DeleteRawAttendance;
DeleteRawAttendance is declared as INTEGER and is a configuration
variable taken from separate table.
The statement results in conversion error.
How do i correct it?
Thanks.
            DELETE FROM HRM_ATTENDANCERAW
WHERE HRM_ATTENDANCERAW.ADATE < CURRENT_DATE - :DeleteRawAttendance;
DeleteRawAttendance is declared as INTEGER and is a configuration
variable taken from separate table.
The statement results in conversion error.
How do i correct it?
Thanks.