Re: RadiusNt with Oracle

Dale E. Reed Jr. ( (no email) )
Tue, 03 Feb 1998 16:10:36 -0800

I need a function to get the CURRENT date. Somethint like what
RadiusNT uses in the INSERT statement:

INSERT Into Calls(CallDate, .... ) VALUES (CurrDate, .... )

Any ideas there?

Flemming Eriksen wrote:
>
> OK
>
> Std. Oracle Date function is
>
> to_char(sysdate,'DD-MON-YY') = (02-FEB-98)
> or
> to_char(sysdate,'DDMMYY') = (020298)
>
> BUT
>
> It is easy to create a function that is called with just "CallDate"
> In Oracle functions can't be called with "()" without something inside, this
> call will work CallDate(020298)
>
> Hope it helps
>
> Flemming
>
> ----------------------------------------------------------
> RadiusNT Mailing List lists@iea-software.com

-- Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com