T-SQL datetime2 and datetime functions should return supported types in fabric warehouse

In Fabric Warehouse T-SQL datetime functions like GETDATE(), GETUTCDATE() return DATETIME which is not supported on the fabric Warehouse
Similarly SYSDATETIME() and SYSUTCDATETIME() return DATETIME2(7) but fabric Warehouse supports only precision up to 6. 

Those fuctions should return supported data types. 

Initial issue with some code examples:
issues with datetime2 and datetime functions in fabric warehouse and datetime functions in fabric warehouse