Monthly Archives: September 2006

Oracle and getting Milliseconds from Sysdate… [Systimestamp]

First, you can’t. Sysdate doesn’t support going to milliseconds.  However, starting with Oracle 9, you can getting milliseconds from another system source : SYSTIMESTAMP. SELECT to_char(sysdate, ‘HH24:MI:SS’), to_char(systimestamp, ‘HH24:MI:SS.FF6’) FROM dual; Powered by Qumana Advertisements

Posted in Oracle | 4 Comments

Oracle SELECT with an array using an IN

SELECT with an array with an IN declare     — CREATE OR REPLACE TYPE PROD_TYPES.TYPE_NUMBER_ARRAY AS TABLE OF NUMBER    nt_src     prod_types.type_number_array := PROD_TYPES.TYPE_NUMBER_ARRAY();    — Constructor         nt_dest     prod_types.type_number_array := PROD_TYPES.TYPE_NUMBER_ARRAY();    — Constructor      begin     — Test data (no order)     select         product_version_id    bulk collect     into         nt_src    from product_version … Continue reading

Posted in Oracle | 3 Comments

ActiveSync Issues

Well, I ran into some ActiveSync issues last night. Basically, I was working with MicroTorrent, and wanted to see what my Windows Firewall settings were.  I had the firewall off, but when Windows realized that I "looked" at the settings … Continue reading

Posted in ActiveSync, T-Mobile MDA, WindowsMobile5 | 1 Comment

WindowsMobile Links to Review Outliner (WindowsMobile and Desktop) Personal Voice Recorder… The JETware Hands-free Extension provides additional functionality to the built-in Windows Mobile support for the Bluetooth Hands-Free Profile. Powered by Qumana

Posted in T-Mobile MDA, WindowsMobile5 | Leave a comment

WindowsMobile Links of Relevance

Jason Langridge’s WebLog – MR Mobile! ( Powered by Qumana

Posted in T-Mobile MDA, WindowsMobile5 | Leave a comment

Determine IP address of a VM Ware Player sessions running a Linux distribution

Recently, I started playing with VMWare Player (  I do some work in Unix/Linux, but not a lot.  I’ve always been able to do what I needed, however I couldn’t remember what it took to determine what the IP address … Continue reading

Posted in Virtualization | Leave a comment

T-Mobile Accessories

Well, I can say that I am very disappointed that I can’t find anyone that carries a silicon case for US version of the MDA.  If anybody finds one, leave me a post / comment. Powered by Qumana

Posted in T-Mobile MDA | Leave a comment