Oracle - Varchar

Here is how to turn a varchar into a timestamp

select to_timestamp('2022-07-12 07:35:00 AM', 'YYYY-MM-DD HH:MI:SS AM') dt, d.*
from limsQAM.wims_data d
where location='SSB I-8 BAC' 
and sampnum='2207120091' and  final=500