Re: Wrong date show up in On-Line Table

Dale E. Reed Jr. ( (no email) )
Fri, 11 Sep 1998 01:51:46 -0700

Admin wrote:
>
> The system clock on the SQL server machine was correct.
>
> Did the SQL server got a clock of its own instead of using
> the machine system clock?

No. It uses the system clock. The last time I saw this problem
it was a date with the SQL Server. Are the current calls still doing
it? The CallDate column is a GetDate() value, which tells SQL Server
to insert the current date/time.

> ----------
> > From: Dale E. Reed Jr. <daler@iea-software.com>
> > To: Admin <info@all.com.au>
> > Cc: emerald@iea-software.com
> > Subject: Re: Wrong date show up in On-Line Table
> > Date: Friday, September 11, 1998 4:54 PM
> >
> > Admin wrote:
> > >
> > >
> > > Recently we have all the calls show up in the On-Line table as
> > > say today instead of 11 Sep 98 but show up as Jul 23 1998
> > >
> > > The date on the hosting computer and the max are both correctly set to
> > > 11 sep 98.
> > >
> > > But expire date still work correctly so expired MBR can not log on.
> > >
> > > Since all calls record was recorded as happened in July so we have
> blank
> > > Sep call table.
> > >
> > > Any reason why this is happening?
> >
> > The date on the SQL Server itself is the only clock used by RadiusNT.
> > Check that clock.
> >
> > --
> > 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

-- 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