Support Questions
Find answers, ask questions, and share your expertise

Custom Masking Timestamp

New Contributor

Hello, Im trying to mask a timestamp so that we can only see the year but not the dates or time. is it possible?


I fouind this solution in the forums but it doesnt work. 


cast(mask(cast(to_date({col}) as date), 'x', 'x', 'x', -1, '1', 1, 0, -1) as timestamp)
Any advice is appreciated. 
Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.