Re: [sqr-users] Date logic question

["George Jansen" <GJANSEN@aflcio.org>]

Why not in your superior select 

Begin-Select 
...
entry_dt
Trunc(Sysdate - entry_dt) days_elapsed
..

End-Select

and then just use &days_elapsed?

>>> Ivan.Turner@qwest.com 08/20/04 07:02PM >>>
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

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