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

What is data definition language?

1088


Why do we use procedures in pl sql?

1039


How much does sqlite cost?

1035


Can we call a function containing dml statements in a select query?

974


What is %rowtype in pl sql?

987


what is the bond code in materialized view?

3002


Why use truncate instead of delete?

1015


Do we need commit after truncate?

1078


Explain what is sql*plus?

1140


How do you update f as m and m as f from the below table testtable?

1858


How can I change database name in sql?

1081


what is a scheduled jobs or what is a scheduled tasks? : Sql dba

958


How many unique keys can a table have?

1012


what is bcp? When does it used? : Sql dba

988


what is a record in a database ? : Sql dba

1061