The following tables list the [!INCLUDEtsql] date and time functions. See Deterministic and Nondeterministic Functions for more information about determinism. [!INCLUDEtsql] derives all system date ...

They can be executed against any database, in a stored procedure or other scripts, just like all other T-SQL statements. Here, I'll discuss conversion functions and the first date and time function.

TL;DR: if you want to use date/time values from a SQL Server table in PowerApps ... which can be done with the Text function: Patch( '[dbo].[tablename]', selectedRecord, { AbsoluteTimeValue: ...