Using SQLite

Name

datetime() — Decode time string into date and time

Common Usage

datetime( timestring, modifier, ... )

Description

The datetime() function takes a timestring value plus zero or more modifier values and returns a text value in the format YYYY-MM-DD HH:MM:SS. It is equivalent to the call strftime( '%Y-%m-%d %H:%M:%S', timestring, ... ).

See Also

strftime(), date(), time()