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

select to_char(sysdate,'ddsp-month-yyyysp') from dual;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution

2262


What is the difference between nested table and varray?

998


Is sqlexception checked or unchecked?

967


How do you create a db file?

1012


Is it possible to link two groups inside a cross products after the cross products group has been created?

1002


Which join condition can be specified using on clause?

952


Which operator is used in query for pattern matching?

1087


What is the use of non clustered index?

989


Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1036


how to get help information from the server? : Sql dba

939


What is relationship? How many types of relationship are there?

1174


Is sql a microsoft product?

945


Which is better varchar or nvarchar?

994


How do I count rows in sql query?

986


How do I use google cloud in sql?

1084