Help

From 2 digit year to 4 digit year

Topic Labels: Dates & Timezones
327 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Vasilii_Lysenko
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello, who can give an advice how to
22 to 2022
23 to 2023 etc…

I guess I can just concat “20” & MyDigits
maybe there is possible more elegant solution?

UPD: I Found solution with DATETIME_FORMAT(‘01/01/’&MyDigits, ‘YYYY’)

0 Replies 0