I have a table called "tblHotlineOpgaver". In there I have a date field called "dmyHotlineDate" where dates are stored as yyyy-mm-dd (no time). The dates are an import from another source.
The date column is sortable as dates.
I need a select distinct where I can extract the MONTH and YEAR - and to make it a little more difficult - I need it in Danish formats.
So - in US English January 2011 would read:
In Danish it would read: