Expiration Value

[Marinko Tarlac]

Well here is how I did it.

I have one table (users) and inside that table I have a field for 
expiration in YYYY-MM-DD format. When I check option to control this 
date, I transfer this date in radcheck table but before that I convert 
it in format we spoke about.

Here is query how to do it.

SELECT DATE_FORMAT( `ex_date` , '%M %d %Y %H:%i:%s' ) AS ex_date FROM 
users WHERE user='some_user';

Tim White wrote:
> The format isn't easily sortable or useable in a SQL compare 
> operation. It also requires slightly more work to generate. The simple 
> format of "YYYY-MM-DD HH:MM:SS" makes more sense to me. It is easily 
> human readable, and is also easily machine readable, isn't locale or 
> language dependent.
>
> Basically, it means that to do any operations on the table regarding 
> the Expiration date, where I only want dates between a range, I have 
> to get all dates, and sort them outside of SQL.
>
> I'm not sure if print.c is the right place for this, but I've not had 
> a chance to look at the code.
>
> Tim
>
> Marinko Tarlac wrote:
>> Well what problem do you have with this format?
>>
>> Best regards
>>
>> On Tue, Feb 26, 2008 at 10:21 AM, <A.L.M.Buxey at lboro.ac.uk 
>> <mailto:A.L.M.Buxey at lboro.ac.uk>> wrote:
>>
>>     Hi,
>>     > Tim White wrote:
>>     > > Bummer. Does anyone know how to get a format that doesn't use
>>     Words
>>     > > (month Name)?
>>     >
>>     >   Edit src/lib/print.c to print dates in a different format.
>>      Or, make a
>>     > suggestion for the format you like...
>>
>>     hmm, a feature request?   what variable in the config though?
>>     print_time ?
>>
>>     print_time = human
>>     print_time = UTC
>>     print_time = unix ?
>>
>>     alan
>>     -
>>     List info/subscribe/unsubscribe? See
>>     http://www.freeradius.org/list/users.html
>>
>>
>> ------------------------------------------------------------------------
>>
>> -
>> List info/subscribe/unsubscribe? See 
>> http://www.freeradius.org/list/users.html
>
> -
> List info/subscribe/unsubscribe? See 
> http://www.freeradius.org/list/users.html
>