Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Julian Time Conversion

My data is imported from JDE. I have 2 separate columns for Date and Time.  Eg: Date: 121195 Time: 224012   How can I convert Time from Julian format to HH:MM:SS format? I want it as a separate ...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Anonymous 

you may try

CONVERT ( TableName[Date], DATETIME ) + CONVERT ( TableName[Time], DATETIME )

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    That didn't work, unfortunately.

     

    What I want is to fill the '?'. But what I'm getting is this Calculated Datetime.