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.

Date format conversion, typo in documentation

2 posts in General Discussion Last posting was on 2009-08-31 19:47:34.0Z
George Brink Posted on 2009-08-31 19:30:49.0Z
From: George Brink <siberianowl@yahoo.com>
User-Agent: Thunderbird 2.0.0.22 (Windows/20090605)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Date format conversion, typo in documentation
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: <4a9c24e9$1@forums-1-dub>
Date: 31 Aug 2009 12:30:49 -0700
X-Trace: forums-1-dub 1251747049 10.22.241.152 (31 Aug 2009 12:30:49 -0700)
X-Original-Trace: 31 Aug 2009 12:30:49 -0700, vip152.sybase.com
Lines: 13
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28239
Article PK: 77486

I think there is a typo in SyBooks Online in the chapter:

Adaptive Server Enterprise 15.0 > Reference Manual: Building Blocks >
Transact-SQL Functions > Chapter 2: Transact-SQL Functions > convert

Table Date format conversions states that formats 111-114 are all equal
to [yy]yy/mm/dd. But in reality, all of them are different.
111 - [yy]yy/mm/dd
112 - [yy]yymmdd
113 - [yy]yy/dd/mm
114 - mm/[yy]yy/dd

Just tested with server 15.0.3 ESD#1


Sherlock, Kevin [TeamSybase] Posted on 2009-08-31 19:47:34.0Z
From: "Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com>
Newsgroups: sybase.public.ase.general
References: <4a9c24e9$1@forums-1-dub>
Subject: Re: Date format conversion, typo in documentation
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a9c28d6$1@forums-1-dub>
Date: 31 Aug 2009 12:47:34 -0700
X-Trace: forums-1-dub 1251748054 10.22.241.152 (31 Aug 2009 12:47:34 -0700)
X-Original-Trace: 31 Aug 2009 12:47:34 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28240
Article PK: 77483

Most definitely a doc bug in the 15.0 docs, but fixed in the 15.0.2
documentation release. Check there for the most recent doc fixes.

http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc36271.1502/html/blocks/X41864.htm

"George Brink" <siberianowl@yahoo.com> wrote in message
news:4a9c24e9$1@forums-1-dub...
>I think there is a typo in SyBooks Online in the chapter:
>
> Adaptive Server Enterprise 15.0 > Reference Manual: Building Blocks >
> Transact-SQL Functions > Chapter 2: Transact-SQL Functions > convert
>
> Table Date format conversions states that formats 111-114 are all equal to
> [yy]yy/mm/dd. But in reality, all of them are different.
> 111 - [yy]yy/mm/dd
> 112 - [yy]yymmdd
> 113 - [yy]yy/dd/mm
> 114 - mm/[yy]yy/dd
>
> Just tested with server 15.0.3 ESD#1