_first_day_month() function

[venkiatmaruthi]

Hi,

This function is working fine.
_first_of_month(current_date)

But I am not able to give maually the date. its giving error.
_first_of_month('1-10-2010')

I tried this way as well but no result.
_first_of_month(cast('1-10-2010',Date))

help me plz....

[venkiatmaruthi]

ok I made it at last.

_first_of_month(2010-01-15)

this is working now.

[sir_jeroen]

if it's oracle you could also use: trunc(<date field>;'MM') MM = truncate date to first of month; Same for YYYY: truncate to first of year... etc.

[venkiatmaruthi]

Thanks for your suggesion.