I am using julianday('now') to set the insertedon date to my tables.
The value needs to be returned to the client via Web Service so that
the client and return it later to get the next inserted record. I am
currently returning it as a double, somewhere along the way it is
getting trunkated:
From 2454976.5929914005 to 2454976.592991
How best to solve this issue? I am thinking it is best to convert to
a string format for transport via Web Service and convert back to the
native format for the next select. My option problem is I cannot make
heads or tails of how to convert the double into
YYYY-MM-DDTHH:MM:SS.SSS and back.
Might there be a better way?
Sam
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
