|
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
:)
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 -----
Sent: Tuesday, August 13, 2002 2:30
AM
Subject: RE: (RADIATOR)
Expiration
There are a whole mess of date formatting options in the
manual:
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 |
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
|
