(RADIATOR) timestamp ?

[chairarth]

Hi Tim,

As your suggestion , I cann't  change datatype of TIME_STAMP field
(located on SQL Server 7) from int to datetime cause it shows error
message " Conversion form 'int' to datetime is not supported on the
connnected database server" .

Anyway if we can change TIME_STAMP formaty ,  can RAmin List Usage 
still show sessions  correctly (I'm not sure that it will take effect to
Radmin Scripts e.g. listUsage.pl or not)

Thanks
Chairath
 
 

Tim McCullagh wrote:

> Hi Chairath May be something like this will help   AcctColumnDef
> xdate,Timestamp,integer-date,to_date('%Y %m %e')
>  AcctColumnDef
> xtime,Timestamp,integer-date,to_date('%H:%M:%S') or  AcctColumnDef
> xdate,Timestamp,integer-date,to_date('%Y %m %e %H:%M:%S'')It means you
> need to write this format to your radusage table though hth Tim
>
>      ----- Original Message -----
>      From: chairarth
>      To: radiator
>      Cc: pisutsak
>      Sent: Wednesday, 30 May 2001 12:06
>      Subject: (RADIATOR) timestamp ?
>       Hi ,
>
>      By now we implement Radiator with Radmin .  Due to we don't
>      wanna let dailup users access to Radmin to check their own
>      usage time. And we have web server (implement on ASP
>      Language) to serve our customers already . Therefore , we
>      plan to let our users check usage time on this server . But 
>      when we check at RADUSAGE Table , we found that  the value
>      of "TIME_STAMP" is int ( e.g. 990781489) .
>
>      So how can we write ASP Scripte to show value of TIME_STAMP
>      like RAmin List Usage show ( e.g. 25/05/2001 16:04) .
>
>      Thanks
>      Chairath
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20010530/c8a81abb/attachment.html>