How to find last day of the month in sql query
Answers were Sorted based on User's Feedback
Answer / vishwa
below query will get the last day of the month
select last_day(sysdate) from dual
| Is This Answer Correct ? | 14 Yes | 0 No |
Answer / ajit
select TO_CHAR( last_day(sysdate), 'day')
from dual
| Is This Answer Correct ? | 12 Yes | 2 No |
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 |
Does oracle roll back the transaction on an error?
how to increment dates by 1 in mysql? : Sql dba
Can a primary key be a foreign key?
What are predefined functions in sql?
How do I audit the sql sent to the server?
What is parameter substitution in sql?
how to retrive only second row from table?
What is the limitation on the block size of pl/sql?
Is left join faster than inner join?
how to create a table index in mysql? : Sql dba
Wat is SGA ?
What is varchar example?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)