```SELECT datetime unix time unixepoch localtime FROM time `

Question

```SELECT datetime unix time unixepoch localtime FROM time ```

Esteban · Answer

Thank you It s from the SQL documentation I couldn t understand the syntax

fritz · Answer

I don t remember where I found that syntax referenced but it is essentially ```SELECT datetime myColumn InputTimeFormat OutputTimeModifier FROM table ```

Esteban · Answer

Cool OutputTimeFormat could be any time zone

fritz · Answer

fritz · Answer

See section 3 Modifiers

fritz · Answer

1 NNN days 2 NNN hours 3 NNN minutes 4 NNN NNNN seconds 5 NNN months 6 NNN years 7 start of month 8 start of year 9 start of day 10 weekday N 11 unixepoch 12 localtime 13 utc

fritz · Answer

```datetime == strftime Y m d H M S ```

Esteban · Answer

Thank you slightly smiling face

fritz · Answer

For comparisons also remember there is ```SELECT true AS within last 30 days WHERE myColumn lt datetime now 1 month ```

seph · Answer

the `datetime` function is pretty overloaded that list of modifiers comprises date addition truncation and some very limited parsing