locked
Times all return as 12:00:00 am RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi folks.

    I've run into another one I can't seem to put my finger on. In my tables, there are columns that include times. However, the query is displaying those times as either "1" or "0". This seems to be the only value that is not pulling. Is there a way to pull exactly what is in the original tables (i.e. 5:00:00 AM) instead of the 1/0?

    Thursday, April 13, 2017 8:51 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    I figured it out!

    In case anybody else runs into this, I had to go into the Advanced editor on the query, and change the return value for those columns from:

    {"SOURCE", Int64.Type}

    to:

    {"SOURCE", type time}

    I'm sure it was a user error in how I set up the query. But lesson learned: check the query language.

    • Marked as answer by RobVanWinkle Friday, April 14, 2017 2:00 PM
    Friday, April 14, 2017 2:00 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Have you tried changing the type of the column to time?
    Friday, April 14, 2017 1:53 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I figured it out!

    In case anybody else runs into this, I had to go into the Advanced editor on the query, and change the return value for those columns from:

    {"SOURCE", Int64.Type}

    to:

    {"SOURCE", type time}

    I'm sure it was a user error in how I set up the query. But lesson learned: check the query language.

    • Marked as answer by RobVanWinkle Friday, April 14, 2017 2:00 PM
    Friday, April 14, 2017 2:00 PM