Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
robmarr789
Contributor
Contributor
‎2018-05-23 04:17 AM

convert date time field to month year-

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.

3,641 Views
0 Likes
11 Replies
sunny_talwar
MVP
MVP
‎2018-05-25 05:02 AM

In response to PrashantSangle

As far as I know... it would not... may be OP changed his req .. I am not sure... but I missed the part where this was needed to be done in SQL...

263 Views
PrashantSangle
MVP
MVP
‎2018-05-25 05:19 AM

In response to sunny_talwar

I can understand, you have given answer as per qlik load syntax. 

My question is to Robert because he specifically write note that he want it into SQL.

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
263 Views