Re: How do I get current date and time
"Matthew Balraj" <email@example.com> wrote in message
> In SQL 2005 Select getdate() would return the current date and
> time. What is the equivalent in NexusDB.
> I want to use it in an After insert trigger to populate a time stamp field
E.g. select current_timestamp from #dummy;
Alternatively you could modify the table in Enterprise Manager to populate
the timestamp field on insert via the data dictionary, potentially removing
the need for the trigger (if that is all you use it for).
When _creating_ a new table, this can be done in SQL as:
drop table if exists mytable;
create table mytable (
tstampField timestamp default current_timestamp,
Will Owyong [NDX]
Newcastle, NSW, AUSTRALIA