![]() You can then format c_date as YYYYMM for display when you query it, if that is what you need, via to_char. IBM Explorer for z/OS Aqua (or simply Aqua) is a continuous delivery release train platform that brings together a set of Eclipse-based mainframe development tools and offerings in order to provide z/OS application developers and system programmers an easy way to install, deploy and maintain our IBM Eclipse-based products. You should consider switching to ANSI join syntax too. I’ve also removed the extra to_date call. WHERE ML.NAME != MD.NAME and ML.ID != MD.ID Select MAX(ML.NAME), ML.ID, TRUNC(CHK_DATE, 'MM') If you’re only interested in the year and month then the closest you can get is to store midnight on the first of the month, which you can get with trunc: INSERT INTO CS_LOG(NAME, ID, C_DATE) ![]() If you have problems installing or getting the workbench to run, check out the Eclipse. ![]() To get started, run the program and go through the user and developer documentation provided in the help system or see the web-based help system. Your string doesn’t match that implicit format, which is causing the error you’re seeing. On this page you can find the latest builds produced by the Eclipse Project. That implicit conversion is using your NLS settings, and from that is expecting a longer value to match the NLS date format. The string you’re generating as YYYYMM is being implicitly converted to a date by the insert, as that is the target column’s data type. ![]() Dates have an internal representation, they always have all the date/time components and can then be formatted for display however you want.
0 Comments
Leave a Reply. |