Login
Products
Sales
Support
Downloads
About
Home
»
Technical Support
»
ElevateDB Technical Support
»
Support Forums
»
ElevateDB SQL
»
View Thread
View Thread
The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
CAST problem
Wed, Jan 16 2019 10:12 AM
Permanent Link
Roy Lambert
NLH Associates
Team Elevate
Before I report this as a problem I'd like to know if this is right
SELECT
_CurrentBalance,
CAST(_CurrentBalance AS VARCHAR(12))
FROM Banks
"_CurrentBalance" DECIMAL(19,2) DEFAULT 0 NOT NULL,
When I cast it it goes from 100.00 to 100
Roy Lambert
Wed, Jan 16 2019 11:22 AM
Permanent Link
Tim Young [Elevate Software]
Elevate Software, Inc.
timyoung@elevatesoft.com
Roy,
<< When I cast it it goes from 100.00 to 100 >>
Yeah, unlike date/times, there's no display formatting for CAST when it comes to numeric types. It's on the list, but I haven't added it yet.
Tim Young
Elevate Software
www.elevatesoft.com