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 / nithya
u can use 'to_char' function.
to_char('us date','indian date format model')
| Is This Answer Correct ? | 1 Yes | 4 No |
What do you mean by a tablespace?
It's Urgent? How to IMPORT .xls & .txt file into ORACLE?
What is a sub query? What are its various types?
How to define an external table with a text file?
How to rollback the current transaction in oracle?
How to recover a dropped table in oracle?
What are the differences between char and varchar2 in oracle?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Please explan Why static query is more faster than dynamic query ?
How can I get column names from a table in oracle?
How do I start tns listener?
what is null value?