Zum Hauptinhalt gehen

Kommentare

2 Kommentare

  • Permanently deleted user
    I have the same issue!  I was already using views in my database so I just converted the date fields to strings in the query and that was a temporary fix.

     

    Here is my SQL Server query string, 101 is a date format of MM/DD/YYYY

     

    CONVERT(CHAR,P.PERMIT_START,101) AS PERMIT_START 
    0
  • Permanently deleted user
    Hi Joshua,

     

    It looks it is a time zone difference/problem. What’s the date-time for feature above in the DB? 13/7 @7PM or 14/7 @1AM? We had a similar problem and we resolved it adding conversions to same time zone where needed. There is also a “Data Time Zone” setting in layer properties under “Fields” tab … that might help …

     

     
    0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.