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

what is the difference between to_char and to_date
functions?

Answer Posted / susan

To_char is to convert number or date(string format) to character format.
To_date is from character format to date,only fetches d data when dere s valid number..

Is This Answer Correct ?    2 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is inner join faster than left join?

1188


How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1217


What is rename in sql?

970


Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1070


Can we insert data into view?

897


what are the advantages of using stored procedures? : Sql dba

1104


what is text? : Sql dba

1065


If the application is running very slow? At what points you need to go about the database in order to improve the performance?

996


What is rowid in sql?

980


What is data type in database?

989


When can we use the where clause and the having clause?

1016


How does cross join work?

948


What are the advantages of pl sql over sql?

1024


Which command is used to delete a trigger?

1326


How to install oracle sql developer?

1042