SQL Eval Function File_GetLastWriteTimeUtc

File_GetLastWriteTimeUtc returns the date and time, in coordinated universal time (UTC), that the specified file or directory was last written to.

File_GetLastWriteTimeUtc (
	@path NVARCHAR (MAX))
RETURNS DATETIME

Parameters

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

Returns

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

Example

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

Contents