Thursday, July 26, 2018

Date Different in Seconds




select a.*, to_char(a.created_dt,'dd/mm/yyyy hh:mi:ss') as start_dt,
to_char(a.updated_dt,'dd/mm/yyyy hh:mi:ss') as finish_dt,
round((a.updated_dt - a.created_dt) * 24 * 60 * 60,1) as seconds
from progress_bar_Status a
order by a.created_dt;

No comments:

Post a Comment