SQLite Forum

Is date/time atomic per statement/transaction?
Login
Does the date/time refer to the exact same timestamp for the whole duration of the statement and/or transaction?

Simple single statement example: `SELECT date('now'),time('now')`

If system clock changes between SQLite's processing of `date('now')` and `time('now')` function calls, what will I get?

Will it be whatever is 'grabbed' from the system clock at the point of execution of each function?

Couldn't find any mention about it in [here](https://sqlite.org/lang_datefunc.html)