Is there a way to change sqlite to use my machine's TZ instead of GMT ? CURRENT_TIMESTAMP is currently displaying GMT. I need it as the default value for a record timestamp column.
Asked
Active
Viewed 72 times
0
amphibient
- 29,770
- 54
- 146
- 240
-
while that solves the problem with one table, it doesn't do it across the whole application. so it partially answers it – amphibient Nov 27 '13 at 20:02
-
It solves it for every date/time call in the database. What else do you want? (And you asked for one table ...) – CL. Nov 27 '13 at 20:35
-
i wanted to set CURRENT_TIMESTAMP to always be localtime – amphibient Nov 27 '13 at 20:38