Simple MySQL query issue - VisualCron

Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.

Welcome Guest! To enable all features please Login or Register.

itibook
No customer Topic Starter

2009-09-18T17:28:39Z

Hi,

I have tried a task with a simple SQL query "select * from"

but I get the following exception in the log

Unable to convert Mysql date/time value to System.datetime

any idea?

thanks in advance

ciao

Luca

Sponsor

Forum information

Wanna join the discussion?! Login to your Forum forum account or Register a new forum account

Support
Official support

2009-09-18T19:37:37Z

1. Is the date a time stamp or normal date?
2. Which version of mysql are you running?

Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!

itibook
No customer Topic Starter

2009-09-18T19:58:50Z

Hi,

1- datetime field
2- MySQL 5.0.45

thanks

Support
Official support

2009-09-18T20:16:42Z

When you say "in the log". Are you referring to the SQL Explorer or Output of Task or VisualCron log window?

Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!

itibook
No customer Topic Starter

2009-09-18T20:18:36Z

in the task log

Support
Official support

2009-09-18T20:46:06Z

Try using the date_format function so that it returns a string like this:

SELECT DATE_FORMAT(columnname, '%H:%i:%s');

Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!

itibook
No customer Topic Starter

2009-09-23T14:58:12Z

Hi Henrik,

sorry for the late reply... your suggestion worked, thanks again!