Forum Discussion

ashrafezz817's avatar
ashrafezz817
Regular Visitor
1 year ago
Solved

Converting to Time Error

Hello, I am currently working in DirectQuery mode with Oracle and encountering an issue while trying to convert a number data type column to time. Initially, when attempting to convert...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi ashrafezz817 

     

    I put your question to the test:

     

    First, determine if the data in your database is in time format.

     

     

    Connect using DirectQuery mode in desktop. And check that the data type is correct.

     

     

     

    Create a column or measure.

     

     

    Column Hour = HOUR('timeTable'[INV_TIME])

     

     

     

    Measure Hour = HOUR(SELECTEDVALUE('timeTable'[INV_TIME]))

     

     

    Here is the result.

     

    Regards,

    Nono Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi ashrafezz817 

 

I put your question to the test:

 

First, determine if the data in your database is in time format.

 

 

Connect using DirectQuery mode in desktop. And check that the data type is correct.

 

 

 

Create a column or measure.

 

 

Column Hour = HOUR('timeTable'[INV_TIME])

 

 

 

Measure Hour = HOUR(SELECTEDVALUE('timeTable'[INV_TIME]))

 

 

Here is the result.

 

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.