At 01:26 PM 25/02/2003 +0000, you wrote:

>Do any of the IBO components let me get the server's date/timestamp?
>
>I have a query:
>
>select *
>from table1
>
>which returns a few dates and I want to do some tests on these dates
>using the current date. Rather than amending my query to return the
>current_date and being forced to list every column I want returning
>in the select, are there alternative means of getting the servers
>date/timestamp?

select * is bad practice. Period. It's not even hard work to do a column
list, if you use the SQL tab of the property editor to construct your queries

But if you don't care about it, you can easily get the server timestamp as
a computed column in your query without supplying a full column list of the
real output fields:

select table1.*, cast('now' as timestamp) as server_time
from table1

The output column will be called server_time, natch. Remember to tell IBO
that it's a computed column (COMPUTED attribute in ColumnAttributes).

Helen