SELECT CHOOSE(2, 1, 'Option 1', GETDATE(), 3.14159, PI() );
what is the data type of the output of the following SELECT statement?

The CHOOSE logical function introduced in SQL Server 2012 returns the data type with the highest precedence from the set of types passed to the function. Here DATETIME has the highest precedence than others