issues with datetime

Dec 7, 2010 at 9:48 AM

I have found many issues using datetime filters and output.

In the argument parser you can't use : character, i.e. using -tables:"table where mydate >= '20101205 05:00:00'"

And in inserting data in WriteDataValue method: I am using 

string dateStr = date.ToString("yyyyMMdd HH:mm:ss").Replace(".", ":");

to permit correct datetime conversion.

May be I am wrong, but hope this helps..

Marco

Feb 2, 2011 at 3:49 PM

.. other issues with real datatype..

Great work anyway!

Mar 4, 2011 at 10:06 PM

Hi Sorry for the late response.

I'll do some testing around date time, I wasn't aware of an issue. I guess it may depend on how Sql Server is configured as to how it handles dates, but there are ways around this.