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?
- 1 Answers
- 3863 Views
- I also Faced
- E-Mail Answers
Answer / nithya
u can use 'to_char' function.
to_char('us date','indian date format model')
| Is This Answer Correct ? | 1 Yes | 4 No |
What should be the return type for a cursor variable.Can we use a scalar data type as return type?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is Partitions in Table ?
How to load data through external tables?
Why is oracle so popular?
i want department wise maxmum salary and empolyee name
Is there a function to split a string in plsql?
List the types of joins used in writing subqueries?
Display the order number and the number of months since the order was shipped for all orders that have been shipped in the last year (365 days). (Hint: Unshipped orders will have a null value).
What are the extensions used by oracle reports?
What are group functions in oracle?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
Oracle General 
