SQL Eval Function File_GetLastAccessTime

File_GetLastAccessTime returns the date and time the specified file or directory was last accessed.

File_GetLastAccessTime (
	@path NVARCHAR (MAX))
RETURNS DATETIME

Parameters

  • path: The file or directory for which to obtain access date and time information.

Returns

A DateTime object set to the date and time that the specified file or directory was last accessed. This value is expressed in local time.

Example

SELECT SQLNET::File_GetLastAccessTime('C:\Temp\MyTest.txt')

Contents