Home » Developer & Programmer » Reports & Discoverer » Discoverer 4.1 - get first date of month using sysdate
Discoverer 4.1 - get first date of month using sysdate [message #135646] Thu, 01 September 2005 11:55 Go to next message
Old Dog, needs new tricks
Messages: 13
Registered: September 2005
Location: Iowa
Junior Member
I have been running into walls when I try to get the first day of the current month.

I've tried to use EUL_DATE_TRUNC(SYSDATE, 'MM'), but I get July 1, 1900, not 2005. I thinking that might have something to do with how our system may be set up. When I use SYSDATE for other things, I do get the current date.

Any ideas?

Thanks for your help.

Report message to a moderator

Re: Discoverer 4.1 - get first date of month using sysdate [message #136043 is a reply to message #135646] Mon, 05 September 2005 10:36 Go to previous messageGo to next message
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
Try this, both in Discoverer:
eul_trunc_date(sysdate,'MM') -> 01-SEP-00
trunc(sysdate,'MM') -> 01-SEP-05

So, a bug in eul_trunc_date? I don't know, but the regular SQL trunc sysdate can be used too.

Regards,
Sabine

Report message to a moderator

Re: Discoverer 4.1 - get first date of month using sysdate [message #136169 is a reply to message #136043] Tue, 06 September 2005 08:26 Go to previous message
Old Dog, needs new tricks
Messages: 13
Registered: September 2005
Location: Iowa
Junior Member
Works like a champ!!! Thanks!! I appreciate your help with this!

Report message to a moderator

Previous Topic: custom folder problem
Next Topic: Show SQL of a rep ...or a form
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jun 23 15:07:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.