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.

ASE 15.x datetime

12 posts in General Discussion Last posting was on 2012-05-25 17:54:44.0Z
DJ Posted on 2012-05-23 19:48:18.0Z
Sender: 4f3f.4fbd3e5b.1804289383@sybase.com
From: DJ
Newsgroups: sybase.public.ase.general
Subject: ASE 15.x datetime
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4fbd3f02.4f60.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 23 May 2012 12:48:18 -0700
X-Trace: forums-1-dub 1337802498 172.20.134.41 (23 May 2012 12:48:18 -0700)
X-Original-Trace: 23 May 2012 12:48:18 -0700, 172.20.134.41
Lines: 3
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31135
Article PK: 74024

The datetime data type supports 3 positions after the
decimal for milliseconds. Is it possible to define a table
column that supports 6 positions after the decimal?


Rob V Posted on 2012-05-23 20:09:50.0Z
From: Rob V <rob@sypron.nl>
Reply-To: rob@sypron.nl
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:12.0) Gecko/20120428 Thunderbird/12.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: ASE 15.x datetime
References: <4fbd3f02.4f60.1681692777@sybase.com>
In-Reply-To: <4fbd3f02.4f60.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: <4fbd440e$1@forums-1-dub>
Date: 23 May 2012 13:09:50 -0700
X-Trace: forums-1-dub 1337803790 10.22.241.152 (23 May 2012 13:09:50 -0700)
X-Original-Trace: 23 May 2012 13:09:50 -0700, vip152.sybase.com
Lines: 27
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31136
Article PK: 74031


On 23-May-2012 21:48, DJ wrote:
> The datetime data type supports 3 positions after the
> decimal for milliseconds. Is it possible to define a table
> column that supports 6 positions after the decimal?

Yes, use the 'bigdatetime' or 'bigtime' datatype. For these, you must be
running ASE 15.5 or later; in pre-15.5 only the 3-millisec precision
'datetime' is available.

--
HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Professional DBA for Sybase ASE, IQ, Replication Server

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase IQ Quick Reference Guide" (new!)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------