If server is in US and client is in india there is timezone
is diffrence, How can we display date in indian time when
data is displayed from US server timezone?
Answer Posted / nithya
u can use 'to_char' function.
to_char('us date','indian date format model')
Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What is recovery manager in Oracle?
Will you be able to store pictures in the database?explain.
What are the arithmetic operations?
How many types of segments in Oracle?
How to convert a date to char in oracle? Give one example.
how do u setup a replication site?
Describe varray?
Explain oracle left join with an example?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
How to change system global area (sga) in oracle?
How to pass parameters to procedures?
What is index-organized table in Oracle?
What is an oracle and why it is used?
Write a trigger example in oracle?
What are a collation and state the different types of collation sensitivity?