SQLite Date and Time Functions (2007)
The document describes default date and time functions in SQLite. This document is a supplement to the function documentation found on the SQL Expression Syntax page. Function Overview Five date and time functions are available, as follows: date( timestring, modifier, modifier, ...) time( timestring, modifier, modifier, ...) datetime( timestring, modifier, modifier, ...) julianday( timestring, modifier, modifier, ...) strftime( format, timestring, modifier, modifier, ...) All five functions