Hi,
i have a table which holds dates like
'2011-12-31 09:00' and i now want to write a query which gives me 2 columns.
First column holds the givin datetime from my table and the second column
should show the datetime from first row but 12 hours before. for example:
'2011-12-31 09:00'
NG Information Systems
Advanced Analytics Directorate
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of looki [looki1...@yahoo.com]
Sent: Friday, June 17, 2011 6:10 AM
To: sqlite-users@sqlite.org
Subject: EXT :[sqlite] need help
On 17/06/2011 12:10, looki wrote:
First column holds the givin datetime from my table and the second column
should show the datetime from first row but 12 hours before. for example:
'2011-12-31 09:00' '2011-12-30 21:00'
'2011-12-31 12:15' '2011-12-30 00:15'
...
looks simple but datetime
Black, Michael (IS) michael.bla...@ngc.com wrote:
sqlite create table t(d date);
sqlite insert into t values('2011-12-31 09:00');
sqlite insert into t values('2011-12-31 12:15');
sqlite select d,substr(datetime(d,'-12 hours'),1,16) from t;
2011-12-31 09:00|2011-12-30 21:00
2011-12-31