I've search the forums and can't seem to find a definate answer on this...
From my web app, I want to update a field called "DateUpdated" with the current date/time each time I update a row.
The "DateUpdated" column must be a user readable date/time.
I want to use the date/time from the SQL Server (i.e. GETDATE()) not from the web server (i.e. Date.Now)
I want to do so without making an extra call to SQL Server to retrieve the time.
I want to do so without the use of triggers.
Is this possible?