search

just-bi / odxl

Open Data Export Layer
Apache License 2.0
13 stars 7 forks source link

ODXL does not recognize OData datetime syntax #32

Open rpbouman opened 7 years ago

rpbouman commented 7 years ago

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 commented 7 years ago

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 commented 7 years ago

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 notifications@github.com 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 https://github.com/just-bi/odxl/issues/32#issuecomment-317365622, 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)