Basically we will have one server wich will have multiple instances belonging to different countries.

So we planned for creating each individual database with their respective time zone.(We are using Oracle9i Release 1).

So I created a database with time zone as '+09:30'.

But when I give select to_char(sysdate,'hh24:mi:ss') from dual ; it is giving the server's time.

How do I accomplish this?

But when I g