SQL - inserting yearmonth variable
Good morning list.. I am trying to insert a YEAR and MONTH into my sql table. I have in the past, used a stored procedure for the accounting start/stop, which worked well.
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...
I tried adding: Yearmonth = $(date +%Y%m) As a variable, and then putting it into the sql query like: accounting_start_query = "INSERT INTO ...<snip>'${Yearmonth}' But that didn't work. Could someone please help me with getting a year & month variable set? THANKS!!! Steve
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.
participants (2)
-
Alan DeKok -
Steven Staples