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 to find last day of the month in sql query

Answer Posted / sujit pingale

select to_char(sysdate, 'day') from dual;

This will print output: tuesday i.e

select last_day(sysdate) from dual;

This will print output: 31-Aug-14

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does truncate free space?

1017


What is foreign key sql?

993


What is sql integrity?

1164


How many aggregate functions are available there in sql?

986


What are the different types of dbms?

1016


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

1015


What is file based approach?

945


What are different types of tables in sql?

999


What is microsoft t sql?

950


What is the difference between inner join and outer join?

999


Explain what is rdbms?

1042


what is a foreign key ? : Sql dba

1087


Is left join faster than inner join?

1128


Explain the uses of database trigger.

1118


what are string data types? : Sql dba

1048