--- In firebird-support@yahoogroups.com, "barfingdog_2004"
<barfingdog_2004@y...> wrote:

> Hi Again Experts:
>
> Upon further investigation, this is an issue of
> me not dealing with a NULL date. The timestamp
> field does not seem to be an issue.
>
> I still need milliseconds in a timestamp, What
> do you suggest for that? An additional millisecond
> field in the table?
>
> Thanks
> Larry

Larry, [ Larry Ellison??? ;) ]
what will you do with millisecods?
don't trust millisecods to be sure create unique field value.
you can get same 'NOW' value with same millisecod even today.
what will do your system when 20GHZ Zentium 7 extrem CPU give you
same TIMESTAMP values for a few following new inserts?
why don't you use
ordey by mytimestamp,rec_id
to get records as inserted order?

Ali