Hi Lisa,
You can try using Segmented Algorithm, split the content in 3 Segment with
1st as 4 Digit (Year)
2nd as 2 Digit (Month) - Set a mask value min & Max between 1 to 12
3rd as 2 Digit (Day) - Set a mask value min & Max between 1 to 28 (to satisfy all the max day in different months)
If you want to retain any part of date (like year, don't use it in Segment, instead mention the range in Preserve Original Values) Or you can engage Professional Services for custom Algorithm.
Hope this helps.
------------------------------
Srinivasan Sarman
Test Data Manager
The Toronto-Dominion Bank
------------------------------
Original Message:
Sent: 01-18-2021 07:51:14 AM
From: Lisa Garczynski
Subject: Masking Date stored as NUMBER
Good morning all,
I have a data warehouse that is storing a date as a number. I tired using DATE SHIFT DISCRETE like the other columns in this domain with a format mask that matches the YYYYMMDD, but it's failing due to the mismatch in data type.
In the SQL I can use a to_date(column_name, 'YYYYMMDD') to convert it to a number, however, for it to be persisted in the database, I'd have to use a different column and then update my original column with the number values.
Is there an easier way to accomplish this task?
Let me know.
Thanks!
Lisa
------------------------------
Lisa Garczynski
Database Engineer III
Paychex
------------------------------