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. Visual Basic 6.0

Dim success As Long
success = 0

' 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
success = sftp.Connect(hostname,port)
If (success = 0) Then
    Debug.Print sftp.LastErrorText
    Exit Sub
End If

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

' After authenticating, the SFTP subsystem must be initialized:
success = sftp.InitializeSftp()
If (success = 0) 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 = 0) Then
    Debug.Print sftp.LastErrorText
    Exit Sub
End If

' Download the directory listing:

Dim dirListing As New ChilkatSFtpDir
success = sftp.ReadDirListing(handle,dirListing)
If (success = 0) Then
    Debug.Print sftp.LastErrorText
    Exit Sub
End If

' Close the directory handle
success = sftp.CloseHandle(handle)
If (success = 0) 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 fileObj As New ChilkatSFtpFile
Dim sbFilename As New ChilkatStringBuilder
Dim caseSensitive As Long
caseSensitive = 0
Dim bLocalDateTime As Long
bLocalDateTime = 0

Dim dt As New CkDateTime
Dim i As Long
i = 0
Dim n As Long
n = dirListing.NumFilesAndDirs
Do While i < n

    success = dirListing.FileAt(i,fileObj)
    If (success = 0) Then
        Debug.Print dirListing.LastErrorText
        Exit Sub
    End If

    Debug.Print fileObj.Filename

    ' Get the last-modified date/time
    success = dt.SetFromRfc822(fileObj.LastModifiedTimeStr)

    ' Get the date/time in other formats 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."