View Single Post
Old 26th May 2010, 11:52 PM
Franz-Leo Chomse [NDX]
Posts: n/a
Default Re: How do I get current date and time

On Wed, 26 May 2010 15:54:14 +0530, "Matthew Balraj" <>

>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

Using a TnxCurrentDateTimeDefaultValueDescriptor for both Insert and
Update - This gives the desired result without any coding

Regards from Germany

Franz-Leo Chomse [NexusDB Expert] (please remove "_x" to reply)