(Visual Basic 6.0) SFTP Get File Date/Times in Different Formats

See more SFTP Examples

Demonstrates how to get remote file date/times in different formats.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

' This requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

Dim sftp As New ChilkatSFtp

' Connect to the SSH server.  
Dim hostname As String
hostname = "my-sftp-server.com"
Dim port As Long
port = 22
Dim success As Long
success = sftp.Connect(hostname,port)
If (success <> 1) Then
    Debug.Print sftp.LastErrorText
    Exit Sub
End If

' Authenticate with the SSH server. 
success = sftp.AuthenticatePw("myLogin","myPassword")
If (success <> 1) Then
    Debug.Print sftp.LastErrorText
    Exit Sub
End If

' After authenticating, the SFTP subsystem must be initialized:
success = sftp.InitializeSftp()
If (success <> 1) Then
    Debug.Print sftp.LastErrorText
    Exit Sub
End If

' Open a directory on the server...
' This example opens the "junk" directory located under the HOME directory of the SSH user account.
Dim handle As String
handle = sftp.OpenDir("junk")
If (sftp.LastMethodSuccess <> 1) Then
    Debug.Print sftp.LastErrorText
    Exit Sub
End If

' Download the directory listing:
Dim dirListing As ChilkatSFtpDir
Set dirListing = sftp.ReadDir(handle)
If (sftp.LastMethodSuccess <> 1) Then
    Debug.Print sftp.LastErrorText
    Exit Sub
End If

' Close the directory handle
success = sftp.CloseHandle(handle)
If (success <> 1) Then
    Debug.Print sftp.LastErrorText
    Exit Sub
End If

' Iterate over the files.
' Examine each filename and indicate those that match *FICHERO*.pdf
' (i.e. the filename contains the word "FICHERO" and ends in ".pdf")
Dim i As Long
i = 0
Dim n As Long
n = dirListing.NumFilesAndDirs
Dim sbFilename As New ChilkatStringBuilder
Dim caseSensitive As Long
caseSensitive = 0
Dim bLocalDateTime As Long
bLocalDateTime = 0
Do While i < n
    Dim fileObj As ChilkatSFtpFile
    Set fileObj = dirListing.GetFileObject(i)
    Debug.Print fileObj.Filename

    ' Get the last-modified date/time
    Dim dt As CkDateTime
    Set dt = fileObj.GetLastModifiedDt()

    ' Get the date/time in any format offered by the CkDateTime object.

    ' such as Wed, 18 Oct 2017 09:08:21 GMT
    Debug.Print "RFC822 format: " & dt.GetAsRfc822(bLocalDateTime)

    ' such as 1990-12-31T23:59:60Z
    Debug.Print "Timestamp: " & dt.GetAsTimestamp(bLocalDateTime)

    ' Such as: "02/16/2008 12:15:12"  where hour is 0 to 23.
    Debug.Print "RFC822 format: " & dt.GetAsIso8601("MM/DD/YYYY hh:mm:ss",bLocalDateTime)

    i = i + 1
Loop

Debug.Print "Success."