your probably looking for curtime()
CURTIME()
CURRENT_TIME
Returns the current time as a value in 'HH:MM:SS' or HHMMSS
format, depending on whether the function is used in a string
or numeric context:
mysql> select CURTIME();
-> '23:50:26'
mysql> select
Can anyone help with (what I hope is) a pretty simple time function
query? I need to extract a set of records from a table based on
separate date and time columns, where both the date and time are older
or equal to now.
For example, my sql query is going to look a bit like this:
select ID, Live
