For example, Mikrotik understands this syntax id | UserName | Attribute | Value | Op 183 | someuser| Expiration | October 04 2011 00:00:00 | == To convert 2011-10-04 into October 04 2011 00:00:00 you should use the next SQL syntax SELECT DATE_FORMAT( `date` , '%M %d %Y %H:%i:%s' ) AS date FROM users WHERE .... Or check the next example SELECT DATE_FORMAT('2011-10-04','%M %d %Y %H:%i:%s') AS date, DATE_FORMAT((NOW()+ INTERVAL 1 day),'%M %d %Y %H:%i:%s') AS date2.... gives date date2 October 04 2011 00:00:00 November 12 2011 23:52:57 (right now is November 11 2011 23:52:57) On 11/11/2011 10:48 PM, Fajar A. Nugraha wrote:
On Sat, Nov 12, 2011 at 2:43 AM, JennyBlunt<jennyshoehorn@me.com> wrote:
I'm looking at your query and am a bit lost as to what I should use for the attributes.
Say I wanted 24 hour voucher - expires exactly 24 hours after first login. I need to give the user some attribute in the db of 86400 seconds - for example I'll call this Access-Duration You can't. It's not a valid attribute. You use existing Expiration instead, where
Expiration = now() + whatever-value-you-want-for-the-account-to-be-valid
There are of course additional details, like what the format of Expiration attribute should be (e.g. using 2011-11-11 won't work), and how to do the actual addition (simply using "+" in mysql won't work).
Hint: try http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html . Should be easy enough, but might take several hours of trying to get the correct syntax right. If you're still confused, hire an experienced mysql developer to help you out.