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.

How do we get total days in month

4 posts in General Discussion Last posting was on 2004-02-26 19:05:12.0Z
Chandresh Patel Posted on 2004-02-25 16:57:25.0Z
From: "Chandresh Patel" <bapashree@yahoo.com>
Newsgroups: ianywhere.public.general
Subject: How do we get total days in month
Lines: 9
Organization: Shreeji Smart Solution
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: acd0e372.ipt.aol.com
X-Original-NNTP-Posting-Host: acd0e372.ipt.aol.com
Message-ID: <403cd3f5@forums-1-dub>
Date: 25 Feb 2004 08:57:25 -0800
X-Trace: forums-1-dub 1077728245 172.208.227.114 (25 Feb 2004 08:57:25 -0800)
X-Original-Trace: 25 Feb 2004 08:57:25 -0800, acd0e372.ipt.aol.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2633
Article PK: 6108

Sybase Anywhere 9.0.0.1108

Is there any way or trick to get total days in month. some time in february
may be leap year or not.
How do we get days of month. If anybudy knows please help me.

Thanks in Advance.


Breck Carter [TeamSybase] Posted on 2004-02-25 17:50:14.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: How do we get total days in month
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <2vnp30pl5v2lpgo18ulofknqtu60mal2gl@4ax.com>
References: <403cd3f5@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: bcarter.sentex.ca
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
Date: 25 Feb 2004 09:50:14 -0800
X-Trace: forums-1-dub 1077731414 64.7.134.118 (25 Feb 2004 09:50:14 -0800)
X-Original-Trace: 25 Feb 2004 09:50:14 -0800, bcarter.sentex.ca
Lines: 20
X-Authenticated-User: TeamPS
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2634
Article PK: 6107

Subtract 1 day from first day of next month.

On 25 Feb 2004 08:57:25 -0800, "Chandresh Patel" <bapashree@yahoo.com>

wrote:

>Sybase Anywhere 9.0.0.1108
>
>Is there any way or trick to get total days in month. some time in february
>may be leap year or not.
>How do we get days of month. If anybudy knows please help me.
>
>Thanks in Advance.
>

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
bcarter@risingroad.com
Mobile and Distributed Enterprise Database Applications
www.risingroad.com


Chandresh Patel Posted on 2004-02-25 18:18:54.0Z
From: "Chandresh Patel" <bapashree@yahoo.com>
Newsgroups: ianywhere.public.general
References: <403cd3f5@forums-1-dub> <2vnp30pl5v2lpgo18ulofknqtu60mal2gl@4ax.com>
Subject: Re: How do we get total days in month
Lines: 29
Organization: Shreeji Smart Solution
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: acd0e372.ipt.aol.com
X-Original-NNTP-Posting-Host: acd0e372.ipt.aol.com
Message-ID: <403ce70e@forums-1-dub>
Date: 25 Feb 2004 10:18:54 -0800
X-Trace: forums-1-dub 1077733134 172.208.227.114 (25 Feb 2004 10:18:54 -0800)
X-Original-Trace: 25 Feb 2004 10:18:54 -0800, acd0e372.ipt.aol.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2635
Article PK: 6117

Great Idea.

"Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> wrote in
message news:2vnp30pl5v2lpgo18ulofknqtu60mal2gl@4ax.com...
> Subtract 1 day from first day of next month.
>
> On 25 Feb 2004 08:57:25 -0800, "Chandresh Patel" <bapashree@yahoo.com>
> wrote:
>
> >Sybase Anywhere 9.0.0.1108
> >
> >Is there any way or trick to get total days in month. some time in
february
> >may be leap year or not.
> >How do we get days of month. If anybudy knows please help me.
> >
> >Thanks in Advance.
> >
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
> bcarter@risingroad.com
> Mobile and Distributed Enterprise Database Applications
> www.risingroad.com


Robert Waywell Posted on 2004-02-26 19:05:12.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <403cd3f5@forums-1-dub> <2vnp30pl5v2lpgo18ulofknqtu60mal2gl@4ax.com> <403ce70e@forums-1-dub>
Subject: Re: How do we get total days in month
Lines: 65
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: accounting-pc.sybase.com
X-Original-NNTP-Posting-Host: accounting-pc.sybase.com
Message-ID: <403e4368$1@forums-1-dub>
Date: 26 Feb 2004 11:05:12 -0800
X-Trace: forums-1-dub 1077822312 172.31.142.157 (26 Feb 2004 11:05:12 -0800)
X-Original-Trace: 26 Feb 2004 11:05:12 -0800, accounting-pc.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2659
Article PK: 6134

Leap years do not occur randomly. There is an international definition of
how to calculate a leap year.

ASA SQL Reference
SQL Data Types
Year 2000 compliance

Leap years

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=B
ug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"Chandresh Patel" <bapashree@yahoo.com> wrote in message
news:403ce70e@forums-1-dub...
> Great Idea.
>
>
> "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> wrote in
> message news:2vnp30pl5v2lpgo18ulofknqtu60mal2gl@4ax.com...
> > Subtract 1 day from first day of next month.
> >
> > On 25 Feb 2004 08:57:25 -0800, "Chandresh Patel" <bapashree@yahoo.com>
> > wrote:
> >
> > >Sybase Anywhere 9.0.0.1108
> > >
> > >Is there any way or trick to get total days in month. some time in
> february
> > >may be leap year or not.
> > >How do we get days of month. If anybudy knows please help me.
> > >
> > >Thanks in Advance.
> > >
> >
> > --
> > SQL Anywhere Studio 9 Developer's Guide
> > Buy the book:
> http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
> > bcarter@risingroad.com
> > Mobile and Distributed Enterprise Database Applications
> > www.risingroad.com
>
>