Re: Changing the format of a date attribute

2009-12-09 Thread Patric
Hi again all :) Patric wrote: Alan DeKok wrote: Patric wrote: Is there any way for me to get my FreeRADIUS-Acct-Session-Start-Time attribute value into that date format? http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_from-unixtime So now I have the

Re: Changing the format of a date attribute

2009-12-09 Thread Alan DeKok
On 09-12-09 11:37 AM, Patric wrote: The problem with the above is that some of those formatting options ('%M %d %Y %H:%i:%s') are also defined as one-character variables, so instead of formatting the date with those options, its replacing each with the variable value, and when Im trying to end

Re: Changing the format of a date attribute

2009-12-09 Thread Patric
Alan DeKok wrote: On 09-12-09 11:37 AM, Patric wrote: The problem with the above is that some of those formatting options ('%M %d %Y %H:%i:%s') are also defined as one-character variables, so instead of formatting the date with those options, its replacing each with the variable value, and

Changing the format of a date attribute

2009-12-08 Thread Patric
Hi everyone, Firstly, thanks Alan for your help with my acct_start_time problem, that was exactly what I was after. The only problem that remains for me is getting the value into a different format so I can store it in my database table. So I have the following setup currently:

Re: Changing the format of a date attribute

2009-12-08 Thread Alan DeKok
Patric wrote: Is there any way for me to get my FreeRADIUS-Acct-Session-Start-Time attribute value into that date format? http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_from-unixtime Alan DeKok. - List info/subscribe/unsubscribe? See

Re: Changing the format of a date attribute

2009-12-08 Thread Patric
Alan DeKok wrote: Patric wrote: Is there any way for me to get my FreeRADIUS-Acct-Session-Start-Time attribute value into that date format? http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_from-unixtime You sir are a genius :) It didnt even occur to me to do it in