i am trying to return a string value when a timestamp field value is null. below is my select statement. I am getting an error message on the data type. Can I use the cast() as varchar to resolve?
case when table.event_id = 5 and table.timestamp isnull then 'n/a' else table.timestamp end as ad_timestamp