12 Dec
2011
12 Dec
'11
12:06 p.m.
Steven Staples wrote:
From what I see, %S will give me a current timestamp, but how can I get/extract the year and month from this? Or is there an easier way to do this...
You should be able to use SQL functions to generate a date, or to parse the date supplied by FreeRADIUS.
I tried adding: Yearmonth = $(date +%Y%m)
I have no idea why you think that would work.
As a variable, and then putting it into the sql query like: accounting_start_query = "INSERT INTO ...<snip>'${Yearmonth}' But that didn't work.
See the FAQ for "it doesn't work". Alan DeKok.