Re: (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