Casting Varchar column having NULL to timestamp

Database

Casting Varchar column having NULL to timestamp

Hi ,

I am trying to write case statement on Varchar column that if its is NOT NULL then casting it to Timestamp . Its working fine if the column has value but for NULL is throwing  - Failed. 6760:  Invalid timestamp

Used Query :

SELECT CASE WHEN COL1 IS NOT NULL THEN CAST ( COL1 AS TIMESTAMP FORMAT 'MM/DD/YYYYBHH:MI:SS') ELSE NULL END FROM TABLE1

Please help me in this .

Thanks in advance