Re: quick and dirty SYSDATE

[Krisjanis Gale <Krisjanis.Gale@NY.FRB.ORG>]

impressive.
having only an SQR 2.5 book on my desk
(i just started last monday) to use a reference,
i was thoroughly unaware of the new
DATE-TIME procedure.  thanks.

(kris)janis p. gale
human resources / systems development
federal reserve bank of new york

>>> Chip Lueck <chip@ACRONET.NET> Tuesday, June 22, 1999 7:08:22 PM >>>
If you like streamlined code, then you can avoid all your
selecting from DUAL (which is Oracle specific).  Anywhere
in your code you can do a :

DATE-TIME ()  format   &memvar

So, in your example, you could get rid of the whole select
sequence and replace it with:

DATE-TIME () 'mm/dd/yy hh:mi:ss' &SYSDATE