CREATE OR ALTER FUNCTION dbo.func() RETURNS DATETIME WITH SCHEMABINDING AS BEGIN RETURN ( '2024-01-22' ) END go SELECT OBJECTPROPERTY(OBJECT_ID('dbo.func'), 'IsDeterministic');