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 delete all rows a table in oracle?
Explain the use of rows option in imp command.
What are data pump export and import modes?
How do I recompile a procedure in oracle?
How to delete a column in an existing table?
What happens to the current transaction if a ddl statement is executed?
What is the data pump export utility?
How to create a stored procedure in oracle?
What is set operator oracle?
How to use subqueries with the in operator using oracle?
What is bulk collect in oracle?
Explain overloading. Can functions be overloaded?
How do I escape a reserved word in oracle?
What is merge statement used for?
Point out the difference between user tables and data dictionary?