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

how will be date change into string

Answer Posted / rajgopal

select to_char(sysdate,'ddsp')||'-'||to_char(sysdate,'mon')||'-'||to_char(sysdate,'yyyysp') from dual

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What language is oracle sql developer?

935


What does select * from mean in sql?

3063


What are the types pl/sql code blocks?

1066


How many types of primary keys are there?

977


What is the difference between the sql*loader and import utilities? : aql loader

973


How to raise user-defined exception with custom sqlerrm ?

1060


What does closing a cursor do?

1240


What are variables in pl sql?

1090


What is vector point function?

999


Is inner join same as self join?

1059


Does sql profiler affect performance?

939


What is pl/sql table? Why it is used?

988


What is the order of sql select?

983


What are the dml statements?

1094


What are different clauses used in sql?

1066