[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
to_date
I'm having a problem using the oracle to_date function in SQR V3.0.12.1
I get the error message :
(SQR 4008) Unknown function or variable in expression: to_date
to_date($end_date,'yymmdd') < to_date($begin_date,'yymmdd')
I have successfully used this function on one of our other unix boxes
running V2.4.2
If you should happen to know of a problem with this release of SQR or spot
errors
in code below (I have tried many different variations) please let me know.
thanks,
Bob
==========================================================
begin-procedure get_edi_date
BEGIN_DATE:
let $begin_date = ' '
show (7,20) clear-line
show (7,20) 'Enter Beginning EDI Date [DD-MON-YY] '
input $begin_date type=date status=#begin_date_status noprompt
if #begin_date_status <> 0 or
isnull ($begin_date)
show (7,20) clear-line
goto BEGIN_DATE
end-if
END_DATE:
let $end_date = ' '
show (8,20) clear-line
show (8,20) 'Enter Ending EDI Date [DD-MON-YY] '
input $end_date type=date status=#end_date_status noprompt
if #end_date_status <> 0 or
isnull ($end_date) or
to_date($end_date,'yymmdd') < to_date($begin_date,'yymmdd')
show (8,20) clear-line
goto END_DATE
end-if
end-procedure
- Follow-Ups:
- Re: to_date
- From: Nathan Treadway <nathant@ONTKO.COM>
- Re: to_date
- From: Nick Moscaritolo <nmoscaritolo@BENTLEY.EDU>