Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

How to view existing locks on the database?

1053


WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2310


What is the database name in oracle?

1021


what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2263


How to use "out" parameter properly?

1080


What happens to the data files if a tablespace is dropped?

1059


What is a private synonym?

1588


Explain an exception and its types?

1073


How to get the Installed Oracle Version Information ?

1123


Is there a function to split a string in plsql?

1055


What is an index associated with a constraint?

1040


What is an oracle data file?

1103


How to use subqueries with the in operator using oracle?

1091


Why is oracle used?

938


What is the difference between "as" and "is" in an oracle stored procedure?

987