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

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1227

Can you upgrade sql express to full sql?

1069

Define a temp table?

1019

When do we use triggers?

1080

What do you mean by rowid?

979

What is procedure in pl sql?

1046

Can we debug stored procedure?

1025

How to find 3rd highest salary of an employee from the employee table in sql?

1083

How to fetch alternate records from a table?

1244

What is auto increment in sql?

1122

How do I view a sql trace file?

1030

Why do we need cursors in pl sql?

1082

What is multiple columns?

1068

How does left join work in sql?

1006

How do I save a sql query?

1014