The docs mention this method:
SELECT strftime('%s', 'now');
1284248196
And this one which includes the fractional part:
SELECT (julianday('now') - 2440587.5) * 86400.0;
1284248196.65098
Both represent Unix Time, the number of seconds passed since January 1, 1970.