@Lawi ...
To my understanding Time always have a date.. but if inyour case 0600 or 1800 i don't think that can get you a date... My Question is Why would you want to store 0600 or 1800 into the db ? you have less control of the output.. i would have preferred a unixtimestamp or a datetime..
TRY THIS
SELECT DATE_FORMAT(CURRENT_TIMESTAMP(), '%H%i') AS _hour, IF ( DATE_FORMAT(CURRENT_TIMESTAMP(), '%H%i') BETWEEN 1300 AND 1500, 1, 0) AS _checkalways replace my 1300 and 1500 to your variables................
On Thu, May 2, 2013 at 1:21 PM, Bwana Lawi <mail2lawi@gmail.com> wrote:
@Peter, sorry for the late replyOn Thu, May 2, 2013 at 11:11 AM, Peter Karunyu <pkarunyu@gmail.com> wrote:2. 0600 to 1800 any day?@Lawi, for my edification; when you say "users to log in ONLY from 1800 to 0600", do you mean:1. 1800 today to 0600 tomorrow OR
For some reason this post is not in my threads.To answer your question, it is ANY DAY. Not tomorrow. As long as the current (server) time is not between those two times the user should not be able to log in.@Ken,The params in the db are for time, not date.Anyway, if the start time is less than end time (meaning they fall on same day) I can do a direct compare.If end time is less than start time, meaning the interval rolls into the next day then all i did was add 24 to both end time and the current time (for comparison)Then I did the same if_______________________________________________
skunkworks mailing list
skunkworks@lists.my.co.ke
------------
List info, subscribe/unsubscribe
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke
_______________________________________________
skunkworks mailing list
skunkworks@lists.my.co.ke
------------
List info, subscribe/unsubscribe
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke