Format Date

Next i show to you an scalar function who should return an text  with the date. The format of the date is according to the  @FormatMask  parameter.

The execution for this function should be something like this.

I’ve created an SP for testing this function.

Result of execution is the following.

 

mssql_test_function_format_date

Feel free to modify it as you need. 🙂

Posted in MSSQL.