Matthew Halliday wrote:
> SELECT strftime('%Y-%m-%d',date_time , '-1 days') as DATE from
> tmp_dspace_import
>
> If I run it as a stand-alone single statement it works.
>
> If I run it as part of a longer query I get either just 131 rows of just
> today's data or a collumn of NULL values.Obviously, the problem is with the longer query. Which you have not shown. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
