Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
DrGenious
Creator
Creator

Hex to Dec TIMESTAMP

HEY,

 

I want to convert "0169af56d96c" from Hex to Dec and then to unix timestamp with java.

 

Thanks a lot.

Labels (2)
1 Solution

Accepted Solutions
DrGenious
Creator
Creator
Author

I found the solution

 

 

//Input is the input row .

Long decimal = Long.parseLong(input,16);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

String new_time = sdf.format(new Date(decimal));

View solution in original post

1 Reply
DrGenious
Creator
Creator
Author

I found the solution

 

 

//Input is the input row .

Long decimal = Long.parseLong(input,16);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

String new_time = sdf.format(new Date(decimal));