hi,
i use numeric values and the sqlite date-functions.
example:
create table if not exists online (ip integer primary key, date number)
insert or replace into online values (12345, julianday('now'))
select id, datetime(date, 'localtime') date from online order by
date desc limit 100
cu, gg
Lloyd schrieb:
Hi,
How can I manage date and time using sqlite? [Do I have to do it
outside sqlite?]
Thanks,
Lloyd.
______________________________________
Scanned and protected by Email scanner
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------