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.

smalldatetime data type

2 posts in General Discussion Last posting was on 2009-07-14 15:21:16.0Z
Ken Posted on 2009-07-14 04:02:31.0Z
Sender: 62ab.4a5c02d0.1804289383@sybase.com
From: Ken
Newsgroups: sybase.public.ase.general
Subject: smalldatetime data type
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4a5c0357.6323.1681692777@sybase.com>
NNTP-Posting-Host: forums-3-dub.sybase.com
X-Original-NNTP-Posting-Host: forums-3-dub.sybase.com
Date: 13 Jul 2009 21:02:31 -0700
X-Trace: forums-3-dub.sybase.com 1247544151 10.22.241.188 (13 Jul 2009 21:02:31 -0700)
X-Original-Trace: 13 Jul 2009 21:02:31 -0700, forums-3-dub.sybase.com
Lines: 7
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:27993
Article PK: 77240

I create a sybase table with a smalldatetime column in ASE
12.5.

I found that I failed to update 'second' datepart in this
smalldatetime field.

Please advise.


Bret Halford [Sybase] Posted on 2009-07-14 15:21:16.0Z
From: "Bret Halford [Sybase]" <bret@sybase.com>
Organization: Sybase, Inc.
User-Agent: Thunderbird 2.0.0.22 (Windows/20090605)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: smalldatetime data type
References: <4a5c0357.6323.1681692777@sybase.com>
In-Reply-To: <4a5c0357.6323.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a5ca26c$3@forums-3-dub.sybase.com>
Date: 14 Jul 2009 08:21:16 -0700
X-Trace: forums-3-dub.sybase.com 1247584876 10.22.241.152 (14 Jul 2009 08:21:16 -0700)
X-Original-Trace: 14 Jul 2009 08:21:16 -0700, vip152.sybase.com
Lines: 14
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28000
Article PK: 77248


Ken wrote:
> I create a sybase table with a smalldatetime column in ASE
> 12.5.
>
> I found that I failed to update 'second' datepart in this
> smalldatetime field.
>
> Please advise.

Not sure what you are expecting; smalldatetime is documented
to have a granularity of minutes.

-bret