Hi All, I am a C++ developer and have basic knowledge of oracle & sql. My job profile involves fixing of bugs. While fixing one of such bugs i found a query to get the unix server time... "SELECT SYSDATE - TO_DATE('01-01-1970 00:00:00', 'DD-MM-YYYY HH24:MI:SS') * 24 * 60 * 60 as currenttime FROM DUAL"... And while fixing the same bug on a WINDOWS background program involved in our project, i need the same result..i.e. unix server time to be inserted instead of the webserver time.... However it doesnt seem to work in this case. i think the problem is with the "dual"... for some reason it isn't executing the queries which fetch from dual..(i know that dual is a dummy table)... any other alternative or any other query.......??? plz help.... thanks in advance..