subject:"\[sqlite\] how to use julianday function"

Re: [sqlite] how to use julianday function

2012-11-08 Thread Simon Davies

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|| >

[sqlite] how to use julianday function

2012-11-08 Thread YAN HONG YE

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||