How can I obtain the month name from a date?
If you have a field X that contains the value 04/15/2018 and you wish to simply return the month name then you use the date_format function:
eg, date_format(X,MMMM)
This will return the value 'April'
Please sign in to leave a comment.
0 comments