(RADIATOR) Expiration

[Dave Kitabjian]

Well, in MS Sql Server you should be able to do something like:

	 
	update USERS 
	set EXPIRATION=DATEADD(mm, 3, '%Y-%m-%d') 
	where .....

 
I don't use SQL with Radiator, so I'm assuming that Radiator will parse
hte %Y stuff before passing it along to the database.
 
Let me know!
 
Dave
:)

	-----Original Message-----
	From: Radius Admin [mailto:radius at vqbn.com] 
	Sent: Tuesday, August 13, 2002 10:11 AM
	To: Dave Kitabjian; radiator at open.com.au
	Subject: Re: (RADIATOR) Expiration
	
	
	Dave,
	 
	I am now using this:
	 
	AcctSQLStatement update USERS set EXPIRATION='%Y-%m-%d' where
.....
	 
	I would like the month to be 3 months from the current date. ie.
+3. How do I do this?
	 
	Thanks
	 

		----- Original Message ----- 
		From: Dave Kitabjian <mailto:dave at netcarrier.com>  
		To: Radius Admin <mailto:radius at vqbn.com>  ;
radiator at open.com.au 
		Sent: Tuesday, August 13, 2002 2:30 AM
		Subject: RE: (RADIATOR) Expiration

		There are a whole mess of date formatting options in the
manual:
		 
	
http://www.open.com.au/radiator/ref.html#pgfId=290952
		 
		Let me know how you make out!
		 
		Dave
		 
		TABLE 2. DateFormat special characters 
Specifier

Is replaced at run-time by:

%%

The percent character

%a

Day of the week, abbreviated

%A

Day of the week

%b

Month, of the year, abbreviated

%B

Month of the year

%c

ctime format: e.g. Sat Nov 19 21:05:57 1994

%d

Numeric day of the month DD, with a leading 0 if necessary.

%e

Numeric day of the month, no leading 0.

%D

MM/DD/YY

%h

Month of year, abbreviated

%H

Hour, 24 hour clock, leading 0

%I

Hour, 12 hour clock, leading 0

%j

Day of the year

%k

Hour

%l

Hour, 12 hour clock

%m

Month number (starting with Jan = 1)

%M

Minute, leading 0

%n

NEWLINE character

%o

Ornate day of month e.g. "1st", "2nd", "25th", ...

%p

`AM' or `PM'

%r

Time format: 09:05:57 PM

%R

Time format: 21:05

%S

Seconds, leading 0

%t

TAB character

%T

time format: 21:05:57

%U

Week number, Sunday as first day of week

%w

Day of the week, numerically, Sunday == 0

%W

Week number, Monday as first day of week

%x

Date format: 11/19/94

%X

Time format: 21:05:57

%y

Year (2 digits)

%Y

Year (4 digits)

%Z

Timezone in ascii. eg: PST

			-----Original Message-----
			From: Radius Admin [mailto:radius at vqbn.com] 
			Sent: Monday, August 12, 2002 11:32 AM
			To: radiator at open.com.au
			Subject: (RADIATOR) Expiration
			
			
			I am trying to update an EXPIRATION field which
is a date field in my users database.
			 
			I am trying to use the following statement.
			 
			AcctSQLStatement update USERS set
EXPIRATION=%t+7776000 where.......
			 
			Is there anyway for me to format the value of
"%t+7776000" to a format which is acceptable to mysql date format.
			 
			Thanks
			 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20020814/090c12a2/attachment.html>