How to get 1st date of a month ?

During preparation of report in *.RDF , there are two things on date & to date
on date is the i/p value , but to date = 1st day of this month on date
how ?

Questions by dinaballavsahoo

Showing Answers 1 - 21 of 21 Answers

Rakesh

  • May 29th, 2012
 

In rdfs sql section,you just formate the to_date as fallow:

sql
where to_char(datefield,dd/mm/yyyy)=to_char(to_date,01||/mm/yyyy)

  Was this answer useful?  Yes

Chip Dawes

  • Jun 4th, 2012
 

To get the first date of a month, truncate the date to the month, like this:

Code
  1. SELECT trunc(my_date,Mon) FROM dual;

  Was this answer useful?  Yes

Krishna

  • Apr 3rd, 2013
 

Select Trunc(SYSDATE,MON) From Dual;

  Was this answer useful?  Yes

Praveen

  • Apr 22nd, 2015
 

SELECT ADD_MONTHS(LAST_DAY(SYSDATE),-1)+1 FROM DUAL;

  Was this answer useful?  Yes

pradeep

  • Apr 24th, 2015
 

SELECT TRUNC(SYSDATE,MM) FROM DUAL

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions