[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: SQLBase & SQR Help



At 04:31 PM 1/7/98 -0800, you wrote:

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

You can just write a select statement to give
you the date right from SQLBase. I'm not familiar
with SQLBase per se, but there is probably a table
with one row, or a dummy table (like DUAL in Oracle).
You can right a select in a procedure like:

begin-select
SYSDATE &Date
  move &Date to $Date
from DUAL
end-select

Hope this helps,
Jeremy


---
Jeremy C. Radwan  <jradwan@concentric.net>  -
http://www.concentric.net/~jradwan/
"Although it is not exactly 'real,' 'cyberspace' is a genuine place. Things
happen
 there that have genuine consequences."  - Bruce Sterling, "The Hacker
Crackdown"