Uploaded image for project: 'Railo'
  1. Railo
  2. RAILO-2149

Wrong date conversion with datatype date and datasource type "Microsoft SQL Server (Vendor Microsoft)"

    Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 4.0.0.013
    • Fix Version/s: None
    • Labels:
    • Steps to Reproduce:
      Hide

      Create a table with a column of type date. Do a select query on the data using the "vendor Microsoft" datasource. Now try again with the jTDS driver (attachment)

      Show
      Create a table with a column of type date. Do a select query on the data using the "vendor Microsoft" datasource. Now try again with the jTDS driver (attachment)

      Description

      The "Vendor Microsoft" driver converts the date column into a timestamp string while adding 2 days. The jTDS driver give back the correct date.

        Gliffy Diagrams

          Attachments

          1. railo-2149a.png
            railo-2149a.png
            68 kB
          2. railo-2149b.png
            railo-2149b.png
            69 kB
          3. railo4mssql.jpg
            railo4mssql.jpg
            160 kB

            Activity

              People

              • Assignee:
                igal-getrailo.org Igal .
                Reporter:
                dazzle1979 Bas van der Graaf
              • Votes:
                1 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: