FUNCTION  fHtmGetString

Converts an HTMID to its string representation


Parameters:
  • htmid bigint: 21-deep htmid of this point
  • returns varchar(max) The string format is (N|S)[0..3]*
    For example S130000013 is on the second face of the southern hemisphere, i.e. ra is between 6h and 12h print dbo.fHtmToString(dbo.fHtmEq(195,2.5))
    gives: N120131233021223031323
  • Input and output parameters

    nametypelengthinoutpnum
    @htmidbigint8input1
     nvarchar-1input0
     sysname-1input0