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.

EBF19956 changed the datetime convert format?

3 posts in General Discussion Last posting was on 2012-08-10 15:11:50.0Z
Eisen Posted on 2012-08-10 01:42:11.0Z
Sender: 6394.50246438.1804289383@sybase.com
From: Eisen
Newsgroups: sybase.public.ase.general
Subject: EBF19956 changed the datetime convert format?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <502466f3.63fe.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 9 Aug 2012 18:42:11 -0700
X-Trace: forums-1-dub 1344562931 172.20.134.41 (9 Aug 2012 18:42:11 -0700)
X-Original-Trace: 9 Aug 2012 18:42:11 -0700, 172.20.134.41
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31331
Article PK: 74220

Dear all
I'm using ASE15.0.3 ESD#4, in it the statement "select
convert(varchar,getdate(),117)" will return "2012/08/10
09:20:07". But when I patch it to ASE15.0.3 ESD#4.1 , it
will be only "9:39AM". what make this different? It already
affect a lot in my report system -- so many reports are now
wrong. Would anyone know what to do about this issue? Thanks

Best Regards
Eisen


Eisen Posted on 2012-08-10 02:05:27.0Z
Sender: 64ad.50246bb3.1804289383@sybase.com
From: Eisen
Newsgroups: sybase.public.ase.general
Subject: Re: EBF19956 changed the datetime convert format?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50246c67.64c8.1681692777@sybase.com>
References: <502466f3.63fe.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 9 Aug 2012 19:05:27 -0700
X-Trace: forums-1-dub 1344564327 172.20.134.41 (9 Aug 2012 19:05:27 -0700)
X-Original-Trace: 9 Aug 2012 19:05:27 -0700, 172.20.134.41
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31332
Article PK: 74228


> Dear all
> I'm using ASE15.0.3 ESD#4, in it the statement "select
> convert(varchar,getdate(),117)" will return "2012/08/10
> 09:20:07". But when I patch it to ASE15.0.3 ESD#4.1 , it
> will be only "9:39AM". what make this different? It
> already affect a lot in my report system -- so many
> reports are now wrong. Would anyone know what to do about
> this issue? Thanks
>
> Best Regards
> Eisen

In general, I found in ASE15.0.3 ESD#4.1, the
convert(...117) is now convert(...17).


Bret Halford Posted on 2012-08-10 15:11:50.0Z
From: Bret Halford <bret@sybase.com>
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:14.0) Gecko/20120713 Thunderbird/14.0
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: EBF19956 changed the datetime convert format?
References: <502466f3.63fe.1681692777@sybase.com> <50246c67.64c8.1681692777@sybase.com>
In-Reply-To: <50246c67.64c8.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: <502524b6$1@forums-1-dub>
Date: 10 Aug 2012 08:11:50 -0700
X-Trace: forums-1-dub 1344611510 172.20.134.152 (10 Aug 2012 08:11:50 -0700)
X-Original-Trace: 10 Aug 2012 08:11:50 -0700, vip152.sybase.com
Lines: 39
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31335
Article PK: 74223


On 8/9/2012 8:05 PM, Eisen wrote:
>> Dear all
>> I'm using ASE15.0.3 ESD#4, in it the statement "select
>> convert(varchar,getdate(),117)" will return "2012/08/10
>> 09:20:07". But when I patch it to ASE15.0.3 ESD#4.1 , it
>> will be only "9:39AM". what make this different? It
>> already affect a lot in my report system -- so many
>> reports are now wrong. Would anyone know what to do about
>> this issue? Thanks
>>
>> Best Regards
>> Eisen
>
> In general, I found in ASE15.0.3 ESD#4.1, the
> convert(...117) is now convert(...17).
>

Back in 12.5.4 and previous versions, style 117/17
was hh:mm:AM(PM). CR 350487 introduced new
format styles 21 and 22 in 15.0, but the engineer coded
what should have been the corresponding styles with full
centry, 121 and 122, as 117 and 118 in error. This error
was corrected under CR 609895/620144 so that 117/17 once
again showed just the time portion.

Sounds like you should convert your reports to use style 121.

1> select convert(varchar, getdate(), 121)
2> go

------------------------------
2012/08/10 09:11:09

(1 row affected)