u can use 'to_char' function. to

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?

Question Posted / nithya

1 Answers
4206 Views
I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

Will you be able to store pictures in the database?

1114

How to define an explicit cursor in oracle?

1031

What is hot backup and logical backup?

1047

Can objects of the same schema reside in different tablespace?

1060

What is a tns service name?

1002

What do you mean by group by clause?

1042

How to create a new view in oracle?

1071

Explain a data segment?

1062

What is the difference between I and G in Oracle?

1091

What is an oracle user account?

984

How to get execution path reports on query statements?

978

What is the use of aggregate functions in oracle?

1023

What is the minimum client footprint required to connect c# to an oracle database?

1087

Explain the use of rows option in exp command.

1086

How a database is related to tablespaces?

1028