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

Answer Posted / susan

To_char is to convert number or date(string format) to character format.
To_date is from character format to date,only fetches d data when dere s valid number..

Is This Answer Correct ?    2 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to create the following trigger: before or after update trigger for each row?

1236

what is meant by urlencode and urldocode? : Sql dba

1089

What does dml mean?

927

What operators deal with null?

1029

What is full join?

895

how to see the create table statement of an existing table? : Sql dba

945

What is where clause in sql?

981

What is cross join example?

940

Does sql view stored data?

897

Define join and name different types of joins?

957

Could you please provide oca (oracle 10g) dumps for my certification ?

5070

What is sql prepared statement?

936

what is the functionality of the function htmlentities? : Sql dba

891

What is sqlite format?

1107

Can we create view in stored procedure?

908