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')

Contents