How I can convert date to char and then ti number?

Question

Please help to sole this task. I need convert date to char and then to number, so that i can perform arithmetic operation and divide the date by 2.

select (sysdate+30+30+89)/2 from dual;

This query doesn’t work and i have no idea how i can convert date to number.

Answer

Based on the understanding of the question I think you need the current day of the year to perform arithmetic operation

  SELECT (to_number(to_char(sysdate,'DDD'))+30+30+89)/2 from dual;

Accepted Answer

Based on the understanding of the question I think you need the current day of the year to perform arithmetic operation  SELECT (to_number(to_char(sysdate,'DDD'))+30+30+89)/2 from dual;

Advertisement

Answer