Non-Deterministic Function in SQL are those functions in SQL, that return different values with each run, even if the input values remains the same throughout. This also takes into account cases where even the state of the database remain unaltered.
Example: Current_Timestamp, GetDate
To know more about Current_Timestamp function click here.
To know more about GetDate function click here.
To know more about Deterministic Functions click here.