Re: HELP!!!! Translate h323-setup/connect/disconnect to ...

[Ruslan A Dautkhanov]

Hello !

Message: 10
From: "Daniil I. Pimonenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: HELP!!!! Translate h323-setup/connect/disconnect to ...
Date: Thu, 19 Feb 2004 15:19:12 +0300
Reply-To: [EMAIL PROTECTED]

Hello ALL!
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...

--
 best regards,
Ruslan A Dautkhanov  [EMAIL PROTECTED]

smime.p7s

Description: S/MIME Cryptographic Signature