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 do I find my oracle client driver version?
What is an external table?
How are extents allocated to a segment?
Explain what are clusters?
what's query optimization and without use of IN AND Exist can we get another way data from query
How would you go about verifying the network name that the local_listener is currently using?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
What is meant by raw datatype?
What are the varoius components of physical database structure of oracle database?
How to connect to a remote server?
What are the different types of modules in oracle forms?
Where do you use decode and case statements?
what is the difference between data migration and production migration.
What are the different oracle database objects?
Where are the settings stored for each instance in oracle?