Monday, September 28, 2015

Oracle Convert datetime to number

you have to convert first to char with no spaces and then convert to number and here is the example for that

select to_number(to_char(sysdate,'hh24mi'))
from dual
;


Yasser

No comments:

Post a Comment