Hi Listmembers,
I have two questions relating on the representation of values retieved from
a MaxDB-Database.
Lets say I have the following table:
CREATE TABLE PRODUCTS (
PID FIXED(10) DEFAULT SERIAL PRIMARY KEY,
NAME CHAR(20) NOT NULL,
PRICE FIXED(8,2) CONSTRAINT PRICE > 0,
EXPIRATION DATE
)
And the following record:
INSERT INTO PRODUCTS
(PID, NAME, PRICE, EXPIRATION)
VALUES
(1, 'FooBar', 12.2, '2005-05-25')
If I select that row from a VisualBasic-Application I will get the follwing
result (on a german localized windows):
SELECT * FROM PRODUCTS WHERE PID = 1
PID: 1
Name: FooBar
Price: 12.2
Expiration: 25.05.2005 00:00:00
No my questions on that example:
1) I know that there is a way to get the price as 12.20 instead of 12.2 by
using a function (or something else) in the select-statement. Unfourtunately
I did not find the posting in the list that describes how to get this result
and although did not find a hint in the manual. Can someone please give me a
hint?
2) Is there a way to get onle the date-information (without the HH:MM:SS)
from the database into the VB-Application that is connected to the DB via
ODBC so I do not have to format the result inside the application?
Thanks & Regards
--
Lust, ein paar Euro nebenbei zu verdienen? Ohne Kosten, ohne Risiko!
Satte Provisionen für GMX Partner: http://www.gmx.net/de/go/partner
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
