[sqlite] decimal function not found

[YAN HONG YE]

my sqlite sql sentens is :
"select '888888', Convert(decimal(5,1),AVG(qph))"
but build the project in c shows the error:
Error: no such function: decimal
how to process this problem?
_______________________________________________
sqlite-users mailing list
sqlite...@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[Roger Binns]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 20/03/12 21:20, YAN HONG YE wrote:
> my sqlite sql sentens is : "select '888888',
> Convert(decimal(5,1),AVG(qph))"

The list of supported functions supplied with SQLite is here:

http://www.sqlite.org/lang_corefunc.html

You can add your own functions using this API:

http://www.sqlite.org/c3ref/create_function.html

It looks like the closest to what you want is the round() builtin.

Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)

iEYEARECAAYFAk9pV6MACgkQmOOfHg372QRvKgCgy7m+Q/914E77+bNX1yUOYyrg
iG0AoJoT5XlN5YWt2O7PGDCaoQAVl/d1
=KdaJ
-----END PGP SIGNATURE-----