No subject

string like formated value for the time column.

insert into acc
(method,from_tag,to_tag,callid,sip_code,sip_reason,*time*,src,dst,duration,setuptime,created
) values
('INVITE','809be9c8-f25c-e011-9bb7-bcaec5119b9b','as67e5ca83','ba9de9c8-f25c-e011-9bb7-bcaec5119b9b at wkst
','200','OK','*2011-04-04 00:31:22*','robert','50624309951',17,0,'2011-04-04
00:31:22')

I'm looking for a way to get the internal epoch value for the timestart of
the dialog.
-- 
Robert

--000e0cd32ed0fde2f404a011f214
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hello,<div><br></div><div>I have been looking to se if I can store on my DB=
 along with the time field that is actually a datetime in the DB, and EPOCH=
 value.</div><div><br></div><div>I have been looking in the acc module docu=
mentation but I haven&#39;t found anything relevant.</div>
<div><br></div><div>I would like to get the EPOCH directly from the dialog =
module in opensips, and not with a DB now() hack.</div><div><br></div><div>=
When I do a opensipsctl fifo dlg_list=A0</div><div><br></div><div><div>dial=
og:: =A0hash=3D3011:1918496183</div>
<div><span class=3D"Apple-tab-span" style=3D"white-space:pre">	</span>state=
:: 4</div><div><span class=3D"Apple-tab-span" style=3D"white-space:pre">	</=
span>user_flags:: 0</div><div><span class=3D"Apple-tab-span" style=3D"white=
-space:pre">	</span>timestart:: 1301897869</div>
<div><br></div><div>I can see the timestart value in EPOCH, how can I acces=
s it?=A0</div><div><br></div><div>I found the variables <font class=3D"Appl=
e-style-span" face=3D"monospace" size=3D"3">functions=A0</font><span class=
=3D"Apple-style-span" style=3D"font-family: Helvetica, Arial; font-size: me=
dium; "><code class=3D"function" style=3D"text-decoration: none; ">fetch_dl=
g_value(name,pvar)=A0or=A0</code></span><span class=3D"Apple-style-span" st=
yle=3D"font-family: Helvetica, Arial; font-size: medium; "><code class=3D"f=
unction">get_dialog_info(attr,var,key,key_val) but I don&#39;t think this i=
s what I&#39;m looking for.</code></span></div>
<div><span class=3D"Apple-style-span" style=3D"font-family: Helvetica, Aria=
l; font-size: medium; "><code class=3D"function"><br></code></span></div><d=
iv><span class=3D"Apple-style-span" style=3D"font-family: Helvetica, Arial;=
 font-size: medium; "><code class=3D"function">From a general sql log, I co=
uld find that the insert query already has a string like formated value for=
 the time column.</code></span></div>
<div><span class=3D"Apple-style-span" style=3D"font-family: Helvetica, Aria=
l; font-size: medium; "><code class=3D"function"><br></code></span></div><d=
iv><code class=3D"function"><font class=3D"Apple-style-span" size=3D"3">ins=
ert into acc (method,from_tag,to_tag,callid,sip_code,sip_reason,<b>time</b>=
,src,dst,duration,setuptime,created ) values (&#39;INVITE&#39;,&#39;809be9c=
8-f25c-e011-9bb7-bcaec5119b9b&#39;,&#39;as67e5ca83&#39;,&#39;ba9de9c8-f25c-=
e011-9bb7-bcaec5119b9b at wkst&#39;,&#39;200&#39;,&#39;OK&#39;,&#39;<b>2011-04=
-04 00:31:22</b>&#39;,&#39;robert&#39;,&#39;50624309951&#39;,17,0,&#39;2011=
-04-04 00:31:22&#39;)</font></code></div>
<meta http-equiv=3D"content-type" content=3D"text/html; charset=3Dutf-8"><m=
eta http-equiv=3D"content-type" content=3D"text/html; charset=3Dutf-8"><met=
a http-equiv=3D"content-type" content=3D"text/html; charset=3Dutf-8"><div><=
br></div>I&#39;m looking for a way to get the internal epoch value for the =
timestart of the dialog.<br>
-- <br>Robert<br>
</div>

--000e0cd32ed0fde2f404a011f214--