RE: (RADIATOR) DATE

[Dave Kitabjian]

Well, there is no one valid DATE Type, unfortunately. Every
application has it's own standard :-\

But to get a date that Sql Server didn't reject, we had to remove the
Day of Week portion, such as Mon, Tue, etc. I think that was all it
took.

Dave

 -Original Message-
 From: auth admin [mailto:[EMAIL PROTECTED]] 
 Sent: Tuesday, July 30, 2002 10:53 PM
 To: [EMAIL PROTECTED]
 Subject: (RADIATOR) DATE
 
 
 We have made our custom windows app to access RADUSERS table, the 
 fields 
 VALIDFROM and VALIDTO are integer types. What is the formula 
 to convert 
 these fields to a valid DATE Type, so we can automatically 
 manage valid 
 dates of the accounts we create.
 
 chris
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

(RADIATOR) DATE

[auth admin]

We have made our custom windows app to access RADUSERS table, the 
fields 
VALIDFROM and VALIDTO are integer types. What is the formula to convert 
these fields to a valid DATE Type, so we can automatically manage valid 
dates of the accounts we create.

chris
-- 
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

(RADIATOR) Date Format in AuthBy SQL

[Separovic, Jason]

I've tried many different combinations but I can't get the date into the
database in the following 

AuthBy SQL
.
   FailureQuery insert into auth(date,user) values('%Y-%m-%d %H:%M:%S',
'%U')
/


I need the date to be in the format -MM-DD HH:MM:SS

I tried entering the date into a char() field and nothing was entered.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

Re: (RADIATOR) Date Format in AuthBy SQL

[Hugh Irvine]

Hello Jason -

On Wednesday 25 July 2001 18:20, Separovic, Jason wrote:
 I've tried many different combinations but I can't get the date into the
 database in the following

 AuthBy SQL
 ..
FailureQuery insert into auth(date,user) values('%Y-%m-%d %H:%M:%S',
 '%U')
 /


 I need the date to be in the format -MM-DD HH:MM:SS

 I tried entering the date into a char() field and nothing was entered.

I suspect you mean 

AuthLog SQL

?

If so, please send me a copy of the configuration file (no secrets), together 
with a trace 4 debug from Radiator showing what is happening.

thanks

Hugh


-- 
Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

(RADIATOR) Date/Format.pm

[Erik Wirring Trimble Danmark]

Hi

I am trying to set up Radiator to work with MySql and in AuthSQL.pm I found that I 
could get a dateformate like a SQL date.
When I tried to Radiator with a accountcolumn specified as a 'formatted-date' I get an 
error saying:
Can't locate Date/Format.pm
and this perl-script  is not on the package I downloaded, so where do I get it from??

Best Regards

Erik Wirring
Chartered surveyor,
Chief software engineer

Email: [EMAIL PROTECTED]
Tel. +45 7733 2257

LE34 TELE A/S
Trimble Center Danmark
Energivej 34
DK-2750 Ballerup
DENMARK

Tel. +45 7733 2233
Fax. +45 7733 2299
http://www.trimble.dk
http.//GPSnet.dk  The Eletronic Referencenet of Denmark

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.