""BSC"" <bsci@...> wrote in message
news:JINLJGPILNHBPBAA@......

> When I select Timestamp columns(from IBConsole or Quickdesk) I don't get

any of the millisecond (4 digits beyond the seconds) precision back. I
would like to use QuickDesk to generate Insert statements for these tables
so that I can repopulate them after I recreate the database. However it
appears that I will lose some of the information from these timestamp
columns?

Just tell the QuickDesk mantainers and the IBConsole maintainers to apply a
bit better and do a better service to their users. The information is there.
It doesn't take a PhD. in computer science to extract it.

> Is there a way to retrieve this level of precision? Is there a better way

to backup the data before dropping the tables?

I imagine you can't use gbak because you want to change the data structure.
Otherwise, I'm not sure why you want to use a text file instead of gbak's
income.

You can try the humble and overlooked isql, the command line tool, not the
#$%&^ thing that comes inside IBConsole.

IBConsole's isql:
select getexacttimestamp() from rdb$database
=> 31-03-2002 4:25:27

Standalone, command-line isql:
SQL> select getexacttimestamp() from rdb$database;
GETEXACTTIMESTAMP
=========================
2002-03-31 04:24:37.8580

You can see the difference. This example shows that the information is
available from tables, too:

SQL> show table ttime;
T TIMESTAMP Nullable
SQL> select * from ttime;
SQL> insert into ttime values(getexacttimestamp());
SQL> select * from ttime;

T
=========================
2002-03-31 04:39:53.6050

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing