Cisco IP Call Detail Record

the datetimeconnect and datetimedisconnect is stored in long integer format

how do i use the sql command select to_char(column_name) as equivalent to ’14-Sep-02′ ?

is there a way to decode the long integer back to readable date format or decode a readable date format 14-Sep-02 to its equivalent long integer value ?

thanks