diff options
author | tilghman <tilghman@f38db490-d61c-443f-a65b-d21fe96a405b> | 2008-01-11 18:35:30 +0000 |
---|---|---|
committer | tilghman <tilghman@f38db490-d61c-443f-a65b-d21fe96a405b> | 2008-01-11 18:35:30 +0000 |
commit | 69d71a14dec4635647d6492725a1ae89269060fc (patch) | |
tree | bc8f09b3045adaac2cd0517416a7df992baeaac1 /cdr | |
parent | bcc664ccd591da5f507c23410f673940d782f795 (diff) |
Port Nick Gorham's timestamp patch to adaptive_odbc, too
git-svn-id: http://svn.digium.com/svn/asterisk/trunk@98269 f38db490-d61c-443f-a65b-d21fe96a405b
Diffstat (limited to 'cdr')
-rw-r--r-- | cdr/cdr_adaptive_odbc.c | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/cdr/cdr_adaptive_odbc.c b/cdr/cdr_adaptive_odbc.c index 98706076d..4c9762082 100644 --- a/cdr/cdr_adaptive_odbc.c +++ b/cdr/cdr_adaptive_odbc.c @@ -404,8 +404,8 @@ static int odbc_log(struct ast_cdr *cdr) year += 2000; lensql += snprintf(sql + lensql, sizesql - lensql, "%s,", entry->name); - LENGTHEN_BUF2(10); - lensql2 += snprintf(sql2 + lensql2, sizesql2 - lensql2, "'%04d-%02d-%02d',", year, month, day); + LENGTHEN_BUF2(17); + lensql2 += snprintf(sql2 + lensql2, sizesql2 - lensql2, "{ d '%04d-%02d-%02d' },", year, month, day); } break; case SQL_TYPE_TIME: @@ -419,8 +419,8 @@ static int odbc_log(struct ast_cdr *cdr) } lensql += snprintf(sql + lensql, sizesql - lensql, "%s,", entry->name); - LENGTHEN_BUF2(8); - lensql2 += snprintf(sql2 + lensql2, sizesql2 - lensql2, "'%02d:%02d:%02d',", hour, minute, second); + LENGTHEN_BUF2(15); + lensql2 += snprintf(sql2 + lensql2, sizesql2 - lensql2, "{ t '%02d:%02d:%02d' },", hour, minute, second); } break; case SQL_TYPE_TIMESTAMP: @@ -445,8 +445,8 @@ static int odbc_log(struct ast_cdr *cdr) year += 2000; lensql += snprintf(sql + lensql, sizesql - lensql, "%s,", entry->name); - LENGTHEN_BUF2(19); - lensql2 += snprintf(sql2 + lensql2, sizesql2 - lensql2, "'%04d-%02d-%02d %02d:%02d:%02d',", year, month, day, hour, minute, second); + LENGTHEN_BUF2(26); + lensql2 += snprintf(sql2 + lensql2, sizesql2 - lensql2, "{ ts '%04d-%02d-%02d %02d:%02d:%02d' },", year, month, day, hour, minute, second); } break; case SQL_INTEGER: |