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
4147 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

What is a dynamic performance view in oracle?

957

What privilege is needed for a user to create tables in oracle?

916

How to convert a string to a date in oracle database?

1009

How to select some columns from a table in oracle?

1021

State all possible different index configurations a table can possibly have?

955

What are the execution control statements in oracle?

1043

What is raw datatype?

1087

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2200

How do I spool to a csv formatted file using sqlplus?

979

Can we commit inside a function in oracle?

932

How are extents allocated to a segment?

1081

What is an oracle database?

1001

Is oracle an operator?

893

How many types of tables supported by oracle?

1031

In oracle there is column command, how will you explain that?

989