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 / sudipta santra

to_char(sysdate,'DD-MON-RRRR HH24:MI:SS')

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is single byte over head in oracle..?

2398


what is the syntax used for partition in tsql? : Transact sql

1014


What are the benefits of stored procedures?

1060


How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1047


What are sql constraints?

1172


Which are sql * plus commands?

1122


How do I send sql query results to excel?

1066


What is count * in sql?

993


Explain ttitle and btitle.

1116


What is difference between inner join and self join?

1079


- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1826


How does postgresql compare to mysql?

1034


Why do we use procedures in sql?

1072


What is the most important ddl statements in sql are?

991


why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1105