> I would like CURRENT_TIMESTAMP to be more accurate than just one second, > any suggestions on how I might do that once? My solution is all a C/C++ > interface, so all features are open to me.
One option would be to create and register a custom SQL function that returned the current time, including fractional seconds. If you format your result as "YYYY-MM-DD HH:MM:SS.SSS", then all standard SQLite date functions should work as-is (up to millisecond resolution). Of course, how you actually get the time from the O/S will depend on your particular O/S. For windows, GetSystemTimeAsFileTime() may be of use. (Resolution around 1~16ms depending on O/S version.) I'm sure others can help with APIs for other Operating Systems. Some links: http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions http://www.sqlite.org/c3ref/create_function.html http://msdn.microsoft.com/en-us/library/ms724397(VS.85).aspx ~Eric _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users