[prev in list] [next in list] [prev in thread] [next in thread] 

List:       apache-db-commons-user
Subject:    [dbutils] Strange exception - "String to date conversion error"
From:       "Security Management" <list-subscriptions () secmgmt ! com>
Date:       2009-08-21 18:45:23
Message-ID: 039701ca228f$8b356340$a1a029c0$ () com
[Download RAW message or body]

I'm running the following query:
select weekday(date(mdy_proc(host_happened_date))) as day, count(*) as num
from alarm_history group by 1

The error is:
java.sql.SQLException: String to date conversion error Query: select
weekday(date(mdy_proc(host_happened_date))) as day, count(*) as num from
alarm_history group by 1 Parameters: []

Here is what it returns when I run it on the console:

[root@sigma scripts]# selectit 'select
weekday(date(mdy_proc(host_happened_date))) as dow, count(*) as num from
alarm_history group by 1'
2 258.0
5 347.0
3 516.0
6 87.0
0 173.0
1 706.0
[root@sigma scripts]#

What in the world does that error mean?

Thanks,
Mike.

[prev in list] [next in list] [prev in thread] [next in thread]