Having a bunch of SQL insert scripts generated in Oracle, I have the requirement to adjust them to be usable with T-SQL in Microsoft SQL Server.
The Oracle export has date formats like this:
RR means that values between 0 and 49 assume the current century, whereas 50 to 99 asume the previous century.
I currently see no SQL Server equivalent to that notation.
The only solution I can think about is to write a quick script that does some Regex and/or string operations to detect the numeric values and add the century by myself so that I could use
YYYY for SQL Server.
Is there a way to express
RR in T-SQL?