Hi!
I'm using MSSql
Wbr DaniiL I. Pimonenko
> > Help me pls. How can I translate Translate
> > h323-setup/connect/disconnect to normal sql like date?
> > Now my VoIP proxy(Mera XPGK) send me Cisco VSA( 25):
> > h323-setup-time=17:42:00.000 MSK Fri Feb 13 2004
> > How I can translate it to SQL Like fromat - 13.02.2004
> 17:42:00.000 ?
>
> It depends...
> what RDBMS you are using?
>
> For example, is PostgreSQL you don't need anything to invent,
> just use type cast explicitly:
>
> isbs=# select '17:42:00.000 MSK Fri Feb 13 2004'::timestamp(0);
> timestamp
> --------------------------
> Fri 13 Feb 17:42:00 2004
>
> or
>
> isbs=# select '17:42:00.000 MSK Fri Feb 13
> 2004'::timestamp(3) with time zone;
> timestamptz
> -------------------------------
> Fri 13 Feb 21:42:00 2004 KRAT
>
> etc...
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
