2010-3月

最新推荐文章于 2020-01-12 21:08:24 发布

aaajj

最新推荐文章于 2020-01-12 21:08:24 发布

阅读量669

点赞数

分类专栏： oracle数据库 C/C++ 文章标签： 2010 date insert table

本文链接：https://blog.csdn.net/aaajj/article/details/6269598

版权

C/C++ 同时被 2 个专栏收录

74 篇文章 1 订阅

订阅专栏

oracle数据库

23 篇文章 0 订阅

订阅专栏

封装

//2010-3 Single //get fields of one row from a char* str comparted by the compart char //the parameter str should not be a const char* str //eg. //char str[1024] = "my-name-is-HanMeimei"; //char seg = '-'; //GetLineFromStr(str, seg); long OciTable::GetLineFromStr(char* str, char seg) { char* phead = str; char* ptail = str; int ipos = 0; while (*ptail != '/0') { if (*ptail == seg) { if (ptail != phead) { *ptail = '/0'; if ((tfields[ipos])->dtype == SQLT_FLT) { *(tfields[ipos]) = atof(phead); } else if ((tfields[ipos])->dtype == SQLT_INT) { *(tfields[ipos]) = atol(phead); } else { *(tfields[ipos]) = phead; } } phead = ptail + 1; ipos++; //in case the number of fields in the str is more than the table's, make the process more safe if (ipos == fnum) { ptail++; break; } } ptail++; } if (ptail != phead) { *ptail = '/0'; if ((tfields[ipos])->dtype == SQLT_FLT) { *(tfields[ipos]) = atof(phead); } else if ((tfields[ipos])->dtype == SQLT_INT) { *(tfields[ipos]) = atol(phead); } else//SQLT_STR { *(tfields[ipos]) = phead; } } Insert(); return 1; }

注意date命令

date -d yesderday

date -d tomorrow

可以这样使用，用来判断当前时间是不是月末，date -d tomorrow 为01 ，则表示是月末