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.

grouping days into weeks

2 posts in PB Infomaker Report Writer Last posting was on 1999-02-26 21:32:27.0Z
janecline Posted on 1999-02-26 08:57:39.0Z
Newsgroups: sybase.public.infomaker.general
Date: Fri, 26 Feb 1999 08:57:39 +0000
From: janecline <janecline@Alliant-Energy.com>
X-Mailer: Mozilla 4.04 [en] (Win95; I)
MIME-Version: 1.0
Subject: grouping days into weeks
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 6
Message-ID: <348_36D66203.B251C821@Alliant-Energy.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6525
Article PK: 241511

I am creating a crosstab reports with the date as the row. This comes in
as days. I want to sum it up as a week total. So instead of a row for
each day, have one row with the weeks total.

Thank You


Terry Dykstra Posted on 1999-02-26 21:32:27.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: grouping days into weeks
Date: Fri, 26 Feb 1999 14:32:27 -0700
Lines: 16
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_bij3y8cY#GA.202@forums.powersoft.com>
References: <348_36D66203.B251C821@Alliant-Energy.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6522
Article PK: 241508

Check your database to see if there is some kind of week() function or a
date-mask you can use. For instance, in Oracle I would use the function
to_char(mydatefield,'IW') to get the week no.

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

janecline wrote in message <36D66203.B251C821@Alliant-Energy.com>...
>I am creating a crosstab reports with the date as the row. This comes in
>as days. I want to sum it up as a week total. So instead of a row for
>each day, have one row with the weeks total.
>
>Thank You
>