I want to select today's record. select * from transaction where trandate=today... Is there's a shortcut for today ? Now ?