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

Can a foreign key be a duplicate?

914


What are local and global variables and their differences?

1093


What are its different types of dbms?

1008


What is a rank in sql?

968


How would you pass hints to the sql processor?

983


What is delete command in sql?

1119


What problem one might face while writing log information to a data-base table in pl/sql?

1169


How do you respond to dementia behavior?

972


Is sql dba a good career? : SQL DBA

996


What is the purpose of using pl/sql?

1147


What are the two types of periodical indexes?

940


what is log shipping? : Sql dba

1125


What does the sign mean in sql?

993


What is group by in sql?

1086


How do I install microsoft sql?

1055