On Sep 18, 2009, at 7:59 PM, Mike Nolting wrote:
> Mr Hipp
>
> I am unable to make any of the date time functions work using your
> examples on your web site when applying to
> data in a table.
> The 'now' variable works great, but there seems to be no way to use
> data from a select query from a table / column.
>
> EG:
>
> SELECT date('now','start of month','+1 month','-1 day'); produces
> real data.
>
> However, I have a field named "Date" and a field named "StartTime"
> in a table named "Reports"
>
> The following queries produce a null result:
> SELECT date(date,'start of month','+1 month','-1 day') from reports
> where reportid='123456'
>
> or (sub query)
>
> SELECT date(select date from reports where reportid='123456', 'start
> of month','+1 month','-1 day')
> or
>
> SELECT date((select date from reports where reportid='123456') ,
> 'start of month','+1 month','-1 day')
>
>
Is the content of the "date" field either a julian day number or an
ISO-8601 format date string?
D. Richard Hipp
d...@hwaci.com
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
