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.