GSAK (Geocaching Swiss Army Knife)
 

Contents - Index


SQL - Conversion functions


Warning: The SQL command was the first introduction of SQL to the macro language. It has many limitations and quirks and is now deprecated. It is provided for here for backwards compatibility only. It is very much recommended that you use the more complete and robust SQLite database engine. See the SQLite() function.



fix(expression,precision)
Returns the string presentation of (numeric) expression with precision number of decimals.

select fix((userid/7), 2) as newid  from users order by newid

asnumber(expression)
Returns (number or string) expression as number. If expression is not a valid floating point number then the function returns 0.

Copyright 2004-2008 CWE Computer Services  
Privacy Policy Contact