SQL Eval Function Directory_GetLastWriteTimeUtc
Directory_GetLastWriteTimeUtc
returns the date and time, in Coordinated Universal Time (UTC) format, that the specified file or directory was last written to.
Directory_GetLastWriteTimeUtc ( @path NVARCHAR (MAX)) RETURNS DATETIME
Parameters
- path: The file or directory for which to obtain access date and time information.
Returns
A DateTime object that is set to the date and time the specified file or directory was last written to. This value is expressed in UTC time.
Example
SELECT SQLNET::Directory_GetLastWriteTimeUtc('C:\Logs')