SQL composite key from datetime functions

Question

I'm trying to make a composite key using some of SQLite's functions but the columns 'newdate' and 'newckey' and appearing blank when I run the query. Any advice?

SELECT *,
       (repeat||date) as 'ckey', 
       (repeat||newdate) as 'newckey' 
FROM (SELECT transactions.id,
             transactions.repeat,
             transactions.date, 
             datetime(transactions.date,'+'||repeattransactions.interval||' days') 
                   AS 'newdate' 
      FROM transactions, repeattransactions 
      WHERE transactions.repeat = repeattransactions.id
     )

But I don't see how this would make a difference, see http://stackoverflow.com/questions/3018018/convert-a-date-to-a-string-in-sqlite — Josh, Apr 19 '12 at 19:09
WHOOPS! Just double checked the format of my dates and I had the extraneous timezone info too! — Josh, Apr 19 '12 at 19:10

score 0 · Accepted Answer · answered Apr 19 '12 at 19:11

0

Nothing wrong with the SQL itself, the dates were stored in the wrong format, including the local timezone info

answered Apr 19 '12 at 19:11

Josh

3,445
5
37
55

SQL composite key from datetime functions

1 Answers1