niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
·  nixdoc.net ·  man pages ·  Linux HOWTOs ·  FreeBSD Tips ·  Forums
navigation Forum index » Databases » Sybase
Sybase convert oddity
Post new topic   Reply to topic Page 1 of 1 [3 Posts] View previous topic :: View next topic
Author Message
rickpoleshuck@verizon.net
*nix forums beginner


Joined: 11 Jul 2006
Posts: 2

PostPosted: Tue Jul 11, 2006 6:16 pm    Post subject: Sybase convert oddity Reply with quote
select convert(numeric(16,2), 5.329),convert(numeric(16,2), '5.329')

returns

5.32 5.33

I would like to understand the logic behind this behavior, if any.
Back to top
Cal
*nix forums beginner


Joined: 18 Jan 2006
Posts: 10

PostPosted: Thu Jul 13, 2006 6:36 am    Post subject: Re: Sybase convert oddity Reply with quote
rickpoleshuck@verizon.net wrote:
Quote:
select convert(numeric(16,2), 5.329),convert(numeric(16,2), '5.329')

returns

5.32 5.33

I would like to understand the logic behind this behavior, if any.

On what Sybase exactly? I have ISQL 12.5 and result is 5.33 and 5.33
(normal).

Cal
Back to top
rickpoleshuck@verizon.net
*nix forums beginner


Joined: 11 Jul 2006
Posts: 2

PostPosted: Thu Jul 13, 2006 12:02 pm    Post subject: Re: Sybase convert oddity Reply with quote
select @@version:
Adaptive Server Enterprise/12.5.0.3/EBF 11442 ESD#4/P/Sun_svr4/OS
5.8/rel12503/1939/64-bit/FBO/Sun Sep 21 05:21:37 2003

Cal wrote:
Quote:
rickpoleshuck@verizon.net wrote:
select convert(numeric(16,2), 5.329),convert(numeric(16,2), '5.329')

returns

5.32 5.33

I would like to understand the logic behind this behavior, if any.

On what Sybase exactly? I have ISQL 12.5 and result is 5.33 and 5.33
(normal).

Cal
Back to top
Google
Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [3 Posts] View previous topic :: View next topic
The time now is Tue Jan 06, 2009 12:34 pm | All times are GMT
navigation Forum index » Databases » Sybase
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts Need to convert domain name before relaying jfinn Postfix 0 Tue Sep 16, 2008 12:51 pm
No new posts Sybase tmanuchandran Sybase 0 Wed Jul 09, 2008 5:06 am
No new posts how to convert byte array into integer msosno01@gmail.com C++ 3 Thu Jul 20, 2006 9:07 pm
No new posts how to convert byte array into integer msosno01@gmail.com C++ 1 Thu Jul 20, 2006 9:01 pm
No new posts how to convert a string into integer priyanka C++ 3 Mon Jul 17, 2006 10:37 pm

Anime | Credit Reports | Loan | Mortgages | Credit Card
Copyright © 2004-2005 DeniX Solutions SRL
 
Other DeniX Solutions sites: Unix/Linux blog |  electronics forum |  medicine forum |  science forum | 
Privacy Policy


Powered by phpBB © 2001, 2005 phpBB Group

[ Time: 0.1008s ][ Queries: 16 (0.0289s) ][ GZIP on - Debug on ]