(RADIATOR) Expiration

[Radius Admin]

MessageDave,

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 
  To: Radius Admin ; 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/20020813/666e926c/attachment.html>