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.
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: