On 9 November 2012 02:42, YAN HONG YE wrote:
> sqlite> select
> fmn,DATE('NOW'),supplierDate,julianday('now'),julianday(supplierDate),julianday('supplierDate')
> from t93c_adl where supplierDate>julianday('now') limit 5 ;
> 854954|2012-11-09|12/01/2012|2456240.61186149||
> 854952|2012-11-09|03/0
sqlite> select
fmn,DATE('NOW'),supplierDate,julianday('now'),julianday(supplierDate),julianday('supplierDate')
from t93c_adl where supplierDate>julianday('now') limit 5 ;
854954|2012-11-09|12/01/2012|2456240.61186149||
854952|2012-11-09|03/01/2013|2456240.61186149||
635604|2012-11-09|05/27/2011|2
2 matches
Mail list logo