SQL ERROR on query that ran perfectly in previous versions
a
anonymous
started a topic
almost 11 years ago
[This topic is migrated from our old forums. The original author name has been removed]
Hi,
I have an error occuring when running a SQL statement (see error message below) in DBVisualiser Version 91.2029 that I just downloaded and installed.
The query has not been modified since the last 12 months and ran perfectly until this morning (before the BETA version was installed).
Has this anything to do with the BETA version ? Windows 7, I installed DBVis BETA with JAVA included.
[Error Code: 1843, SQL State: 22008] ORA-01843: not a valid month
simple query on our 'track&trace' database:
*{color:#FF00FF}+select newartnr as ARTNR, 'W26' as WEEKNUMBER, to_char(to_date(newdaydt),'YYYY') as YEAR, sum(newqty) as QUANTITY from stockevents+*
*+where handlingtype = 'DL1'+ *
*+and newartnr = '314''+*
*+and newdaydt >= '24-06-2013'+*
*+and newdaydt <= '30-06-2013'+*
*+group by 'W26', to_char(to_date(newdaydt),'YYYY'),newartnr+*
*+order by year asc, weeknumber asc, newartnr asc+{color}*
anonymous