Datetime Conversion

Use the conversion function to convert the date format :

To_CHAR('21/02/2016','DD-MON-YYYY')

Here is url where You can learn all about "Standard Date and Time Format Strings" and Custom formatting.

https://docs.microsoft.com/en-us/dotnet/standard/base-types/standard-date-and-time-format-strings

All the best,

Željko Peric

http://www.c-sharpcorner.com/UploadFile/mahesh/working-with-datetime-using-C-Sharp/

Also mention format like (DD/mm/yyyy)