In sql we have situations where we want to extract date from date time and in particular format-- extracting only date from datetime type columnselect n. [id],n. [message],n. [locationid],n.

When we connect an app to a SQL Server table that has a column of type time, the values don't show in a user-friendly format by default in PowerApps. In this post we'll go over some expressions that ...