aboutsummaryrefslogtreecommitdiffstats
path: root/cdr/cdr_adaptive_odbc.c
diff options
context:
space:
mode:
authortilghman <tilghman@f38db490-d61c-443f-a65b-d21fe96a405b>2008-01-11 18:35:30 +0000
committertilghman <tilghman@f38db490-d61c-443f-a65b-d21fe96a405b>2008-01-11 18:35:30 +0000
commit69d71a14dec4635647d6492725a1ae89269060fc (patch)
treebc8f09b3045adaac2cd0517416a7df992baeaac1 /cdr/cdr_adaptive_odbc.c
parentbcc664ccd591da5f507c23410f673940d782f795 (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/cdr_adaptive_odbc.c')
-rw-r--r--cdr/cdr_adaptive_odbc.c12
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: