SQL int to hex conversion little/big endian format

Question

Using MSSMS I'm trying to run the query.

SELECT CONVERT(BINARY(16), 14437)

It results to:

0x00000000000000000000000000003865

But this is what I'm looking for:

0x65380000000000000000000000000000

I tried using reverse but no luck.

SELECT REVERSE(CONVERT(BINARY(16), 14437))

Answer 1

I tried using reverse but no luck.

REVERSE returns a string. Casting back to binary returns your desired results

SELECT CONVERT(BINARY(16), REVERSE(CONVERT(BINARY(16), 14437)))