Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- (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) || '"'
- (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'
- (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'
- to_dms( $x, 'x', 3) -> 62°31′7.951″
- to_dms( $x, 'x', 3, 'suffix') -> 62°31′7.951″E
- to_dm( $x, 'x', 5, 'suffix') -> 62°31.13252′E
Add Comment
Please, Sign In to add comment