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 / madhu

The Simple examples is correct but we take the date in date
format not like sysdate or hiredate.
if u select to_char('some date') and to_date('somedate')
explain with this examples if any one know.

Is This Answer Correct ?    7 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the benefits of pl sql?

1121


How many clustered indexes can be created on a table?

1075


What is a unique constraint?

1078


Can we use view in stored procedure?

902


Why do we need databases?

1048


What is sql prepared statement?

987


What is trigger in sql and its types?

1058


Why do we use procedures?

959


What is input buffer in sql*plus?

1226


How do I order columns in sql?

1008


What is a scalar value in sql?

1073


What is oracle sql developer?

1058


What is java sql driver?

1125


What is the maximum number of triggers, you can apply on a single table?

998


What is sql entity?

1107