you can read it as a whole string using dbExpress TSQLQuery comp... for
example...

showmessage( myquery.FieldByName('FIELD_X').AsString );

HTH,
Kiran Kumar.

-----Original Message-----
From: Szakály Balázs [mailto:szakalyb@...]
Sent: Friday, June 13, 2003 4:43 PM
To: Firebird-Support
Subject: [firebird-support] Millisec part of TIMESTAMP

Hi!

How i can store millisec in a TIMESTAMP field?

insert into ANYTABLE (FIELD_X) values (cast ('2005.01.01 11:22:33.123' as
TIMESTAMP))

this SQL run successfully, but i cannot read back the milisec value from
timestamp.

I try to read fields with borland's dbExpress, and Borland's direct
Interbase controls.

The Firebird cannot store millisec or i cannot read back the values? There
is any client software, which can show tis values
correctly?

(sorry my english...)

Szakály Balázs
szoftver fejlesztő
szakalyb@...
www.microraab.hu <http://www.microraab.hu/>
GSM: +36(30)9363639
Tel: +36(96)510738
Fax: +36(96)510719



[Non-text portions of this message have been removed]

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

*********************************************************************************************************************************************
Meet us @ TECH' 03 WORLD EXPO - NSE COMPLEX, Goregaon (W), MUMBAI on 13th, 14th and 15th June at STALL # 8 / 9 / 10 / 11. http://www.mwti.net
*********************************************************************************************************************************************