Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Month Functions

3 posts in PB Infomaker Report Writer Last posting was on 1999-06-23 18:21:06.0Z
Allen Shapiro Posted on 1999-06-22 20:51:30.0Z
Newsgroups: sybase.public.infomaker.general
Date: Tue, 22 Jun 1999 16:51:30 -0400
From: Allen Shapiro <ashapiro@webstakes.com>
X-Mailer: Mozilla 4.51 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Month Functions
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 6
Message-ID: <348_376FF751.9F8030F@webstakes.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6175
Article PK: 240111

Im an running Infomaker on top of Oracle 7. I want to run a crosstab
based on Month. When I use the Month function it only returns a 1
through 12 value. How can I get the actual month and year to show as
column headers?


Terry Dykstra Posted on 1999-06-23 18:06:29.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: Month Functions
Date: Wed, 23 Jun 1999 12:06:29 -0600
Lines: 14
X-Newsreader: Microsoft Outlook Express 4.72.3612.1700
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3612.1700
Message-ID: <348_lRiOiJav#GA.267@forums.sybase.com>
References: <348_376FF751.9F8030F@webstakes.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6167
Article PK: 240103

I would use the Oracle to_char(yourfield,'YYYY/MM') function instead of the
IM month() function.

--
Terry Dykstra (TeamSybase)
Canadian Forest Oil Ltd.

Allen Shapiro wrote in message <376FF751.9F8030F@webstakes.com>...
>Im an running Infomaker on top of Oracle 7. I want to run a crosstab
>based on Month. When I use the Month function it only returns a 1
>through 12 value. How can I get the actual month and year to show as
>column headers?
>


Allen Shapiro Posted on 1999-06-23 18:21:06.0Z
Newsgroups: sybase.public.infomaker.general
Date: Wed, 23 Jun 1999 14:21:06 -0400
From: Allen Shapiro <ashapiro@webstakes.com>
X-Mailer: Mozilla 4.51 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Month Functions
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 14
Message-ID: <348_37712592.557CA85E@webstakes.com>
References: <348_376FF751.9F8030F@webstakes.com> <348_lRiOiJav#GA.267@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6165
Article PK: 240101

Thanx, I'll try it

Terry Dykstra wrote:

> I would use the Oracle to_char(yourfield,'YYYY/MM') function instead of the
> IM month() function.
>
> --
> Terry Dykstra (TeamSybase)
> Canadian Forest Oil Ltd.
> Allen Shapiro wrote in message <376FF751.9F8030F@webstakes.com>...
> >Im an running Infomaker on top of Oracle 7. I want to run a crosstab
> >based on Month. When I use the Month function it only returns a 1
> >through 12 value. How can I get the actual month and year to show as
> >column headers?
> >