(RADIATOR) format input

[budi wibowo]

i'm runnign radiator 3.6 and use mysql as database
server 
here's is part of my radius.cfg 

<Realm as53-sg>
        <AuthBy SQL>
          DBSource      dbi:mysql:accounting
          DBUsername xxx
          DBAuth xxxx
        AccountingTable as5300
         AcctColumnDef
ctime,%{cisco-h323-connect-time},formatted,substring_index(%s,
'=', -1)

ctime is connect time of my call 
in cisco format it looks like 

cisco-h323-connect-time =
"h323-disconnect-time=*15:36:24.733 UTC Thu Mar 4
2003"

how can i only input 15:36:24 and Mar 4 2003 to mysql
as separate field 
how can i do that


rgds

budi
 



__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.