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 Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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: 
Anonymous
Not applicable
‎2019-07-11 04:11 PM

MySQL output shifting FirstOfMonth to End of Previous Month

Hello everyone,,

OK, this is weird... I am calculating a firstOfMonth value that shows up properly in the last tLog before inserting into MySQL:

 

2019-01-06

2019-01-07

2019-01-08

2019-01-09

 

But when I query the database, all 4 of those show up as:

 

2019-05-31

2019-06-30

2019-07-31

2019-08-31

 

What the heck?

 
 
109 Views
0 Likes
0 Replies