Access SQL NOW() function equal in SQLServer View (1 Viewer)

Rx_

Nothing In Moderation
Local time
Yesterday, 20:25
Joined
Oct 22, 2009
Messages
2,803
My MSAccess queries used the NOW() function to put the data/time the query was run. What is the equal in Microsoft SQLServer2008 for a View?

Recently, created a SQL 2008r2 view for an outside business group.

Wanted to create a field on the View with the date/time stamp for when they view the data. The data is pulled into the GIS mapping group. So, it is important to know how "dated" the maps have become as the permits and surveyers update this kind of thing all the time.

See Attachment:
GETDATE() AS DateDataPulled
creates a contrived column DateDataPulled with the time/date. In SQL Server, there is a TimeStamp - it is much different than the GetDate.

Once added to the View's design, run (or execute it), then on any ODBC linked tables - it was necessary for me to refresh the linked table to see the new field.
 
Last edited by a moderator:

Users who are viewing this thread

Top Bottom