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 can I get column names from a table in oracle?
Explain integrity constraint?
What do you mean by merge in oracle and how can we merge two tables?
How to call a sub procedure?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is the difference between online and offline backups?
What is a trigger and what are its types in oracle?
What is a nested table?
What is redo log?
Point the difference between translate and replace?
How would you best determine why your MVIEW couldnt FAST REFRESH?
How to define an anonymous procedure without variables?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
Explain the use of log option in exp command.
How will you identify oracle database software release?