Answer :

Yes you must include the MI element in the format argument of a TO_CHAR function to include the minutes when displaying time.

What is MI element of a TO_CHAR function?

DATETIME or DATE values are converted to character string values using the TO CHAR function. The TO CHAR function returns an NVARCHAR value after evaluating a DATETIME value in accordance with the date-formatting directive you set.

Using the supplied format, Oracle's TO CHAR function converts a datetime value (i.e., of the DATE and TIMESTAMP data types) to a string. In SQL Server, you can convert a datetime value (DATETIME, DATETIME2 data types, for example) to a string using the CONVERT or CAST functions.

Hence the TO_CHAR function has  to  be  included for  the minutes when displaying time

To know more about TO_CHAR function  follow this link:

https://brainly.com/question/10018401

#SPJ4

Other Questions