Guest User

Untitled

a guest
Jan 19th, 2019
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.86 KB | None | 0 0
  1. (CASE WHEN $x < 0 THEN '-' ELSE '' END) || floor (abs($x)) || '° ' || floor(((abs($x)) - floor (abs($x))) * 60) ||''' || substr( (tostring((((abs($x)) - floor (abs($x))) * 60) - floor(((abs($x)) - floor (abs($x))) * 60)) * 60),1,5) || '"'
  2.  
  3. (CASE WHEN $x < 0 THEN '-' ELSE '' END) || floor (abs($x)) || '°' || floor(((abs($x)) - floor (abs($x))) * 60) ||''' || substr( (tostring((((abs($x)) - floor (abs($x))) * 60) - floor(((abs($x)) - floor (abs($x))) * 60)) * 60),1,5) || '" E'
  4.  
  5. (CASE WHEN $y < 0 THEN '-' ELSE '' END) || floor (abs($y)) || '°' || floor(((abs($y)) - floor (abs($y))) * 60) ||''' || substr( (tostring((((abs($y)) - floor (abs($y))) * 60) - floor(((abs($y)) - floor (abs($y))) * 60)) * 60),1,5) || '" N'
  6.  
  7. to_dms( $x, 'x', 3) -> 62°31′7.951″
  8. to_dms( $x, 'x', 3, 'suffix') -> 62°31′7.951″E
  9. to_dm( $x, 'x', 5, 'suffix') -> 62°31.13252′E
Add Comment
Please, Sign In to add comment