convert date time field to month year-

[robmarr789]

I am bringing in some data from a sql database.

I have a date time field as follows "2017-01-01 00:00:00.000" I am trying to create a MonthYear field than would convert this example to "Jan 2017".

Note I am looking to do this within SQL and not Qlikview at this stage.

[sunny_talwar · Accepted solution]

Look here

convert date time field to month year-