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

to_char conversion function will convert given data to character data whereas to_data will convert given character data into date format model.


Also we can say like to_char conversion function use for convert invalid data into valid data.
and to_date conversion function will convert valid data into invalid.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about various levels of constraint.

881


Is coalesce faster than isnull?

906


What is spool?

992


What is sql character function?

993


how do you tune the slow running queries in oracle db , explain the methodology

2050


what is the difference between nested subquery and correlated subquery?

983


What does an inner join do?

1089


How to write a query to show the details of a student from students table whose

936


how to use 'mysql' to run sql statements? : Sql dba

982


Where is pl sql used?

903


Explain what is a column in a table?

1040


how can you create an empty table from an existing table? : Sql dba

1076


what is an alias command? : Sql dba

1006


Cite the differences between execution of triggers and stored procedures?

1026


What is record in pl sql?

1008