For more information on converting Datetime values to a different format, see DATEFORMAT Function.
Patterns by Example
You can generate a new column of values based on pattern matches from a source column. When you enter example values to match with source values, other values with similar patterns may also be matched based on your entered example value.
Tip: This method provides an easy way to build pattern-based matching for values in a source column.
For more information on transformation by example, see Overview of TBE.