Oracle - SQL - First day of the current month

[ZeroFearX]

Hello,

 

I am trying to generate an automated SQL Report that will always use the current first day of the month. Format: 'YYYY-MM-01'

 

Sadly I dont have the ability to create functions on the database and I do not know how else I can make this work. I saw "SYSDATE()" but I am not familiar with this enough to get it working.

 

Thank you

[FloatingFatMan]

It's been a loooong time since I touched Oracle, so possibly it's changed since, but this should work if I remember correctly...

 

SELECT TO_CHAR(TRUNC(SYSDATE,'MM'),'YYYY-MON-DD HH24:MI') FROM dual;

[BGM]

one of these should do it...

select
  trunc(current_timestamp, 'mm') 
  ,to_char(trunc(current_timestamp, 'mm'))
from dual

[FloatingFatMan]

@OP, did you resolve this in the end? Did mine or BGM's posts help?