Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Timestamp format

  Hi,       Using Add column I have extracted the time in a seperate column from timestamp, but format is like 0. + 24hr formart time, How to remove 0. from the begining and insert a prope...
Need Help
Tips and Tricks
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, Anonymous 

    Please try to change type and select the locale of origin.

    Best Regards,
    Community Support Team _ Eason

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks, the table is from ADX (kusto) and the method is directQuery so I used add column and extracted time from it, but the output was odd. I will try with your Query and check

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, Anonymous 

Please try to change type and select the locale of origin.

Best Regards,
Community Support Team _ Eason