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.

By typing 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?