1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
#include <grass/dbmi.h>
/*!
\fn
\brief
\return
\param
*/
void db_interval_range(int sqltype, int *from, int *to)
{
switch (sqltype) {
case DB_SQL_TYPE_DATE:
*from = DB_YEAR;
*to = DB_DAY;
return;
case DB_SQL_TYPE_TIME:
*from = DB_HOUR;
*to = DB_FRACTION;
return;
}
if (sqltype & DB_YEAR)
*from = DB_YEAR;
else if (sqltype & DB_MONTH)
*from = DB_MONTH;
else if (sqltype & DB_DAY)
*from = DB_DAY;
else if (sqltype & DB_HOUR)
*from = DB_HOUR;
else if (sqltype & DB_MINUTE)
*from = DB_MINUTE;
else if (sqltype & DB_SECOND)
*from = DB_SECOND;
else if (sqltype & DB_FRACTION)
*from = DB_FRACTION;
else
*from = 0;
if (sqltype & DB_FRACTION)
*to = DB_FRACTION;
else if (sqltype & DB_SECOND)
*to = DB_SECOND;
else if (sqltype & DB_MINUTE)
*to = DB_MINUTE;
else if (sqltype & DB_HOUR)
*to = DB_HOUR;
else if (sqltype & DB_DAY)
*to = DB_DAY;
else if (sqltype & DB_MONTH)
*to = DB_MONTH;
else if (sqltype & DB_YEAR)
*to = DB_YEAR;
else
*to = 0;
}
|