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
How to view existing locks on the database?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
What is the database name in oracle?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
How to use "out" parameter properly?
What happens to the data files if a tablespace is dropped?
What is a private synonym?
Explain an exception and its types?
How to get the Installed Oracle Version Information ?
Is there a function to split a string in plsql?
What is an index associated with a constraint?
What is an oracle data file?
How to use subqueries with the in operator using oracle?
Why is oracle used?
What is the difference between "as" and "is" in an oracle stored procedure?