module Type SYSTEMTIME wYear As Integer wMonth As Integer wDayOfWeek As Integer wDay As Integer wHour As Integer wMinute As Integer wSecond As Integer wMilliseconds As Integer End Type
Declare Sub GetSystemTime Lib "kernel32.dll" (lpSystemTime As SYSTEMTIME)form Public Sub GetTime() Dim st As SYSTEMTIME GetSystemTime st Debug.Print "Year - " & st.wYear Debug.Print "Month - " & st.wMonth Debug.Print "DayOfWeek - " & st.wDayOfWeek Debug.Print "Day - " & st.wDay Debug.Print "Hour - " & st.wHour Debug.Print "Minute - " & st.wMinute Debug.Print "Second - " & st.wSecond Debug.Print "Milliseconds - " & st.wMilliseconds End Sub
Type SYSTEMTIME
wYear As Integer
wMonth As Integer
wDayOfWeek As Integer
wDay As Integer
wHour As Integer
wMinute As Integer
wSecond As Integer
wMilliseconds As Integer
End Type
Declare Sub GetSystemTime Lib "kernel32.dll" (lpSystemTime As SYSTEMTIME)form
Public Sub GetTime()
Dim st As SYSTEMTIME
GetSystemTime st
Debug.Print "Year - " & st.wYear
Debug.Print "Month - " & st.wMonth
Debug.Print "DayOfWeek - " & st.wDayOfWeek
Debug.Print "Day - " & st.wDay
Debug.Print "Hour - " & st.wHour
Debug.Print "Minute - " & st.wMinute
Debug.Print "Second - " & st.wSecond
Debug.Print "Milliseconds - " & st.wMilliseconds
End Sub
GetSystemTime 取到的时间格式是GMT 的,与北京时间相差8个小时!
GetLocalTime函数得到本地时间
GetSystemTime函数得到系统时间
date
time等等,看要什么样格式了