PROTECTED]
Sent: Friday, November 17, 2006 6:37 PM
To: SQLite
Subject: [sqlite] Re: Date and time comparison
Karthick V - TLS , Chennai <[EMAIL PROTECTED]>
wrote:
> I need to get the row id for a time which falls within the start and
> end time.
>
> I am using this query.
>
&g
Karthick V - TLS , Chennai <[EMAIL PROTECTED]>
wrote:
I need to get the row id for a time which falls within the start and
end
time.
I am using this query.
select RowID,
strftime('%Y-%m-%dT%H:%M:%S',starttime),
strftime('%Y-%m-%dT%H:%M',endtime) from History where
strftime('%Y-%m-%dT%H:%M',star
2 matches
Mail list logo