ODXL does not recognize OData datetime syntax

[rpbouman]

Currently you can simply pass datetime literal values as strings. But we really ought to support the OData standard syntax, i.e.

datetime'yyyy-mm-dd hh:mi:ss.SSSS'

[joel-myworld]

Hi Roland,

I have the odxl set up in my project, but for some reason the date columns all show "7/9/1905".
I got the sql query using the $format=sql and executed it in the SQL console. There the data results are shown properly. So I guess since the query is correct, the resultSet handling has some problem?

Is there some library file that I should modify to get the date fields as a string?

[rpbouman]

Interesting. Could you please make an issue in github? Please include: 1) a very simple table ddl 2) insert SQL with a few rows of data to demonstrate the issue 3) paste of excel output you receieve 4) paste of excel output you expected. Thanks in advance, Roland.

…

On Mon, Jul 24, 2017 at 11:16 AM, joel-myworld ***@***.***> wrote: Hi Roland, I have the odxl set up in my project, but for some reason the date columns all show "7/9/1905". I got the sql query using the $format=sql and executed it in the SQL console. There the data results are shown properly. So I guess since the query is correct, the resultSet handling has some problem? Is there some library file that I should modify to get the date fields as a string? — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#32 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAngk3esAwEQgH-hBzavtuK3PBy6Di0Eks5sRGD5gaJpZM4M42xx> .

-- Roland Bouman blog: http://rpbouman.blogspot.com/ twitter: @rolandbouman linkedin: http://www.linkedin.com/profile/view?id=5142800&trk=tab_pro Author of "Pentaho Solutions" (Wiley, ISBN: 978-0-470-48432-6 http://tinyurl.com/lvxa88) and "Pentaho Kettle Solutions" (Wiley, ISBN: 978-0-470-63517-9 http://tinyurl.com/33r7a8m)