From 2 digit year to 4 digit year

Ask the community Dates and timezones
#1

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’)

1 Like
#2

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.