[Gambas-bugtracker] Bug #2171: gb.db.odbc: unable to convert date

[bugtracker at gambaswiki.org]

http://gambaswiki.org/bugtracker/edit?object=BUG.2171&from=L21haW4-

Comment #13 by Gianluigi GRADASCHI:

Now, with this code (without debug):

Public Sub Main()
  Dim hRes As Result
  Dim Nx As Integer

    Print "-----------"
  'Db.Debug = True ' enable debug messages
  Try hRes = DbMistral.Exec("SELECT MMGT_DCRE FROM MMGT_MOVIMENTI_MAGAZ_T;")
  If Error Then
    Print "Error";; Error.Text;; Error.Code
  Endif

  For Each hRes
    Inc Nx
    If Nx > 10 Then Break
    Print "Value DATA: " & hRes["MMGT_DCRE"]
  Next

End

Gets into console:

-----------
gb.db.odbc: unable to convert date: 2018-10-31 11:56:03
Value DATA: 10/31/2018 09:56:03
gb.db.odbc: unable to convert date: 2018-11-02 13:01:40
Value DATA: 11/02/2018 11:01:40
gb.db.odbc: unable to convert date: 2018-11-02 14:28:14
Value DATA: 11/02/2018 12:28:14
gb.db.odbc: unable to convert date: 2018-11-05 06:55:04
Value DATA: 11/05/2018 04:55:04
gb.db.odbc: unable to convert date: 2018-11-02 10:57:11
Value DATA: 11/02/2018 08:57:11
gb.db.odbc: unable to convert date: 2018-11-01 15:04:02
Value DATA: 11/01/2018 13:04:02
gb.db.odbc: unable to convert date: 2018-11-01 15:21:29
Value DATA: 11/01/2018 13:21:29
gb.db.odbc: unable to convert date: 2018-11-01 15:21:59
Value DATA: 11/01/2018 13:21:59
gb.db.odbc: unable to convert date: 2018-11-02 10:59:48
Value DATA: 11/02/2018 08:59:48
gb.db.odbc: unable to convert date: 2018-10-31 12:47:01
Value DATA: 10/31/2018 10:47:01
gb.db.odbc: unable to convert date: 2018-11-01 15:31:51

Gianluigi GRADASCHI changed the state of the bug to: Accepted.