I have getting month as integer value by this code EXTRACT(MONTH FROM e.docDate)
. However, I need this to be name of the month e.g. Jan instead of 1
Is it also possible EXTRACTING month-year from date e.g. Jan-2020 ?
Thanks for any hints
I have getting month as integer value by this code EXTRACT(MONTH FROM e.docDate)
. However, I need this to be name of the month e.g. Jan instead of 1
Is it also possible EXTRACTING month-year from date e.g. Jan-2020 ?
Thanks for any hints