RE: [sqr-users] Date logic question

[Bob.Melosi@edwardjones.com]

You will need to add the date format like below:

TO_DATE(&ENTRY_DT,'dd-mon-yyyy')

or what ever format your date is in.


-----Original Message-----
From: Ivan.Turner [mailto:Ivan.Turner@qwest.com]
Sent: Friday, August 20, 2004 6:02 PM
To: sqr-users
Subject: [sqr-users] Date logic question


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