Geo Carncross wrote:
> On Tue, 2006-06-20 at 09:45 +0200, Paul J Stevens wrote:
>> Geo Carncross wrote:
>>
>>> Just FYI: VACUUM is no longer required in sqlite3- the database can
>>> AutoVacuum as necessary.
>> Great.
>
> This change is in the DIFF.
Geo, plz explain again why you want to use UDF for simple access to
timevalues.
Why not use:
CURRENT_TIMESTAMP():
sqlite> select strftime('%Y-%m-%d %H:%M:%S', 'now', 'localtime');
2006-06-20 16:35:22
CURRENT_TIMESTAMP_UNIX():
sqlite> select strftime('%s', 'now');
1150814132
sqlite>
--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
