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 is union, minus and interact commands? : Sql dba

1120


what are the features and advantages of object-oriented programming? : Sql dba

951


What is clustered and nonclustered index in sql?

893


What are all the common sql functions?

968


What is out parameter used for eventhough return statement can also be used in pl/sql?

1013


How to test for null values?

982


what are the 'mysql' command line options? : Sql dba

1015


what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

906


What does where 1 1 mean in sql?

978


What are sql*plus environment variables?

1029


What is a left join?

888


Can we insert data into view?

847


How can we avoid duplicating records in a query?

921


What is a table?

955


What is java sql driver?

1037