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

what is row? : Sql dba

1276


Can I learn sql in a week?

1119


Can you rollback after commit?

1049


Can we write ddl statements in functions?

1182


Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1123


What is the advantage of index in sql?

1015


Which one is better subquery or joins?

1114


If the application is running very slow? At what points you need to go about the database in order to improve the performance?

1051


how to create a test table in your mysql server? : Sql dba

1055


Which table is left in left join?

1061


Can I call a procedure inside a function?

1075


Explain mutating table error.

1261


what are the different type of normalization? : Sql dba

1067


What is column?

1032


What is the starting oracle error number? What is meant by forward declaration in functions?

1041