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 assign values to variables?
What privilege is needed for a user to delete rows from tables in another schema?
What is blob data type in oracle?
Is truncate autocommit in oracle?
Explain an extent?
Can we commit inside a function in oracle?
Which environment variables are absolutely critical in order to run the OUI?
Explain about functional dependency and its relation with table design?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
How do I start tns listener?
Is it possible to split the print reviewer into more than one region ?
Explain integrity constraint?
How to increment dates by 1 in oracle?
How to execute the package in oracle?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.