Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Converting literal date values to Date Format

I have a new project that is pulling in data from a proprietary SQL database.  I am using a query to get the data and it comes through fine, however the date data is showing up as long integers like ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    I think I found the issue: http://lawthirtysix.com/reporting-choices-and-date-handling-in-servicedesk-plus/ 

     

    And if anyone else in the future is looking for a possible answer to this, in my SQL query for a date or time column, I used this: dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + ("RESPONDEDTIME"/1000),'01-01-1970 00:00:00')  AS "Responded Date" 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

When you say proprietary SQL database do you mean not Microsoft or Oracle or IBM but something you wrote or some other vendor?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

I think I found the issue: http://lawthirtysix.com/reporting-choices-and-date-handling-in-servicedesk-plus/ 

 

And if anyone else in the future is looking for a possible answer to this, in my SQL query for a date or time column, I used this: dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + ("RESPONDEDTIME"/1000),'01-01-1970 00:00:00')  AS "Responded Date"