In sql server,I can do this
"select * from table1 where year(ltime) = year(getDate()) and month(ltime) = month(getDate()) and day(ltime) = day(getDate())
the ltime column is datetime type.

but in oracle,I can do this
"select * from table1 where year(ltime) = year(sysdate) and month(ltime) = month(sysdate) and day(ltime) = day(sysdate)
but can not find year(),month,day() function ,How can I do?
please help,thanks