How to Convert Varchar Time Format to Seconds - PL/SQL

 

This will help pl/sql developer to convert a given varchar value to time format.

This useful while you need a time comparison or want to display data in AM/PM format or any other time format.

Here we are converting varchar AM/PM format to seconds for the comparison purpose.

select  to_number(to_char(to_date('11:00 AM','hh:mi AM'), 'sssss')) from dual