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 is the use of composite key constraint?
How to define Data Block size ?
What is tns service name?
emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example
How to do clean up if create database failed?
What is meant by recursive hints ?
What is a table index?
Can we convert a date to char in oracle and if so, what would be the syntax?
I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??
What are the components of Logical database structure of ORACLE database?
What is set operator oracle?
difference between bind variable and variable