RE: [sqr-users] Date logic question

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

Won't it all just default to the native db format?

-----Original Message-----
From: sqr-users-bounces+ivan.turner=qwest.com@sqrug.org
[mailto:sqr-users-bounces+ivan.turner=qwest.com@sqrug.org] On Behalf Of
Bob.Melosi@edwardjones.com
Sent: Friday, August 20, 2004 7:20 PM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] Date logic question

I take that back....You need to add the date format like 'dd-mon-yyyy' 
or 'dd-mm-yyyy' if your native db date format does not match &ENTRY_DT.

--------------------------------------------------

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

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