Let the time zone given by user
+0530
Therefore its 330 minutes / 13200 seconds
select datetime( StartTime,'unixepoch','+13200.0 seconds') from mytable
--- gives you the local time
Select datetime( StartTime,'unixepoch')gives u universal time
Where StartTime is an integer(unixtimestamp
to bother about whether
you are happy or not. The cure for it is occupation.
George Bernard Shaw (1856-1950)
-Original Message-
From: Dennis Cote [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 28, 2006 11:04 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Time formatting
Karthick V - TLS
Hi everyone,
I am trying to generate a time information with the time zone offset
information in the UTC format
-MM-DDTHH:MM:SS.mmm+HH:MM
with the last HH and MM referring to the offset of the timezone hours and
minutes from the GMT. My table is created using the following queries
Hello everyone,
I am trying to retrieve some records from the database using date and time
comparison. The table has three columns, Row Id, Start Time and end Time.
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,
]
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.
select RowID,
strftime('%Y-%m-%dT%H:%M:%S