Topic: MonthBetweenMonth How To Cal Result is Number
How To Query in SQLITE
Month Between Month : Result -1,0, . . . 999
Example
'2016-01-01' - '2014-01-01' = 24
'2016-01-01' - '2015-10-01' = 3
Help me please
Easy For Beginner Student For Me
My Visual Database → SQL queries → MonthBetweenMonth How To Cal Result is Number
How To Query in SQLITE
Month Between Month : Result -1,0, . . . 999
Example
'2016-01-01' - '2014-01-01' = 24
'2016-01-01' - '2015-10-01' = 3
Help me please
A useful resource: https://www.sqlite.org/lang_datefunc.html
It Haven't cal month between month because
-result month is name month or 01-12 not number format 00...9999
in mvd script editor have function MonthsBetween(,) but sqlite query have ???
Um... Help me please
Try this query,
SELECT round((julianday(datefield1) - julianday(datefield1))/30) as MonthsDiff from TableName;
My Visual Database → SQL queries → MonthBetweenMonth How To Cal Result is Number
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi