<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
Hello,<br>
<br>
On 8/5/10 7:00 PM, SIP Projects wrote:
<blockquote cite="mid:4C5AEE38.8050304@gmail.com" type="cite">
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
<font size="-1"><font face="Arial">Using version 1.5.2.<br>
<br>
Trying to migrate acc from db_mysql to db_flatstore to reduce
io wait during heavy dialing. <br>
<br>
However, the default time format changes from normal
YYYY-MM-DD hh:mm:ss to unixtime in flatstore. I tried using
$TF but its format is even more non-standard.<br>
<br>
Is there a way to change time format for either the default
acc time field in the db_flatstore module or $TF?<br>
</font></font></blockquote>
even for mysql internally in kamailio is unix timestamp, but the sql
server keep it as DATE format. With flatstore the value is written
directly.<br>
<br>
$TF is the format as returned by 'date' command.<br>
<br>
What you can do is to use broken-down time pseudo-variables to
create a value in the format you want.<br>
<br>
<a class="moz-txt-link-freetext" href="http://www.kamailio.org/dokuwiki/doku.php/pseudovariables:1.5.x#broken-down_time">http://www.kamailio.org/dokuwiki/doku.php/pseudovariables:1.5.x#broken-down_time</a><br>
<br>
Cheers,<br>
Daniel<br>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
<a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a></pre>
</body>
</html>