Subject Timestamps in ORDER BY Clause?
Author barfingdog_2004
Hi Experts:

If this is an IBPP issue I apologize. Let me
know and I'll post this in that support group.

Using FB1.5 and IBPP 2.3 Beta to build an app
on Win32.

Timestamps in the "order by" clause aren't
working for me:

SELECT
*
FROM
table_name
ORDER BY
time_stamp

Is returning:

*** IBPP::Exception inside Date::GetDate ***

IBPP : Out of range date

I can use IBPP's Timestamp Get(), and then
GetDate() and GetTime() to extract the timestamp's
values.

How do I order a select's results by a timestamp?

Any chance of adding milliseconds to Firebird's
timestamp? That would make my life easier.

Thanks
Larry