Re: SQLBase & SQR Help

["Cooper, Marcus" <MCooper@APL.GT-WIS.COM>]

You might want to try this

Begin-select
@DateToChar(sysdate,'MM/DD/YYYY') &YourVar
from TableName
end-select

Where TableName has only 1 or 2 rows so it doesn't take any time.  Then,
of course, you can use &YourVar as your variable for the current date

I hope this helps

Marcus Cooper
Grant Thornton LLP
mcooper@apl.gt-wis.com


        -----Original Message-----
        From:   Scott Gunter [SMTP:ksgunter@TDYRYAN.COM]
        Sent:   Wednesday, January 07, 1998 6:32 PM
        To:     Multiple recipients of list SQR-USERS
        Subject:        SQLBase & SQR Help

        I need to know how to access the current date in an
        SQR Batch program that is connecting to a SQLBase
        database.

        I use SYSDATE in "where" clauses, but it doesn't work
        in other contexts.

        Thanks in advance for any help.

        Scott
        ksgunter@tdyryan.com