I run a small crawler on a virtual ubuntu server, initiated by crontab hourly. Datetime is inserted by defaulting the date filed to
TIMESTAMP DEFAULT CURRENT_TIMESTAMP.
Table creation looks like this:
CREATE TABLE links (page TEXT, link TEXT, date TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY(page,link));
The datetime gets stored fine, but it one hour off (one hour behind) Norwegian time (GMT +1). The server is located where-ever, I just need it to be on GMT+1.
datein the ssh session I get:
Wed Dec 19 17:26:02 CET 2012
and that is correct (just now).
So where does sqlite3 get it's time from? What must I do to set the time so that sqlite3 gets the time right?