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...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

what is the difference between to_char and to_date
functions?

Question Posted / rajesh

Answer Posted / rajesh

to_char function is used to convert the given data into
character....
eg:to_char(sysdate,'month') which returns month alone...

to_date is used to convert the given data into date data
formate data type....

eg: to_date('070903', 'MMDDYY') would return a date value
of July 9, 2003.

Is This Answer Correct ?    138 Yes 33 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are sql constraints?

1228

What does joining a thread mean?

1077

Can we create index on primary key?

1019

What is rank dense_rank and partition in sql?

1086

What is normalization sql?

1118

differentiate between float and double. : Sql dba

1110

What are tables in sql?

1116

How do I trace sql profiler?

1045

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

1073

What is sql exception?

1012

What is synonyms?

1118

How is use pl and sql?

1108

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1206

How do I save a sql query?

1067

Is coalesce faster than isnull?

1017