MySQL Date Problem - 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.

mspittlehouse
Paid support Topic Starter

2009-10-01T12:31:41Z

Hi,

I have created a task that runs an sql statement. The output is fine apart from the dates which appear like this: "System.Byte[]"

this is an example line:

"train_113" "post trip" "System.Byte[]" "System.Byte[]" "56.22" "yellow"

Any ideas?

Thanks
Mark

Sponsor

Forum information

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

Support
Official support

2009-10-01T12:40:38Z

Check out this post:

http://www.visualcron.co...m.aspx?g=posts&t=855

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

mspittlehouse
Paid support Topic Starter

2009-10-01T12:49:57Z

Hi,

I tried that and no luck

Mark

Support
Official support

2009-10-01T12:51:42Z

What kind of column type is it really? Datetime or Timestamp?

Which version of MySQL are you running?

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

mspittlehouse
Paid support Topic Starter

2009-10-01T12:54:51Z

Server is 5.0.24a-standard-log

The columns are Date columns.

Thanks

Support
Official support

2009-10-01T12:56:22Z

What kind of Connection are you using? Are you using the Native MySQL or ODBC/OLEDB?

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

mspittlehouse
Paid support Topic Starter

2009-10-01T12:57:01Z

Native MySQL

Support
Official support

2009-10-01T12:57:42Z

OK, we will test this and get back to you.

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

Support
Official support

2009-10-01T13:24:35Z

What error did you get when using date_format function on the date column?

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

mspittlehouse
Paid support Topic Starter

2009-10-01T13:42:12Z

#10

No errors at all but the output just contains no dates but System.Byte[] instead:

"Speed & space management" "System.Byte[]" "System.Byte[]" "0.00" "green"

Support
Official support

2009-10-01T13:57:20Z

#11

We installed 5.0.84 (only old version available). We could not reproduce this issue. Date columns should work on the fly and it did return the date without any date_format functions.

I suspect that you don't have a Date column but other column type or that there is a bug in that mysql version you are running.

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