[sqr-users] Date logic question

["Turner, Ivan" <Ivan.Turner@qwest.com>]

Hello out there,

I have another process writing an entry date to a table.  I need to
determine if 10 days have passed from that date before I can take
action.  Will the code below tell me if 10 days have passed using
oracle?

Will my "WHERE" clause work for an oracle db?


        LET #TIME_FRAME = 10
!---------------------------------------------------------------
! Proc: 4050-check-grace-pd-expiration
! Desc: Determine grace period has expired before sending
!          a disco message to the bus and disconnecting.
!---------------------------------------------------------------
Begin-Procedure 4050-check-grace-pd-expiration
        Let $grace_expired = 'N'
BEGIN-SELECT
'X'
        LET $grace_expired = 'Y'
FROM DUAL
where SYSDATE >= TO_DATE(&ENTRY_DT) + #TIME_FRAME
END-SELECT
End-Procedure 4050-check-grace-pd-expiration


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users