Second - Built-in Date & Time Function¶

Purpose¶

Second returns the second from a datetime expression.

Syntax¶

Second(datetime)

Arguments¶

Returns¶

Integer

See also¶

• Date
• DateAdd
• DateDiff
• DatePart
• DateValue
• DateSerial
• Day
• Hour
• InAgedToDays
• InLast4WeeksToSunday
• InLast7Days
• InLastFullMonth
• InLastFullWeek
• InLastYearMTD
• InLastYearYTD
• InLeapYear
• Minute
• Month
• MonthName
• Now
• Time
• TimeSerial
• TimeValue
• WeekAgo
• Weekday
• WeekdayName
• Year

Example¶

dim dtSys

Let dtSys = Now()

Return Second(dtSys) // returns the second of the current time

Notes¶

• When datetime cannot be converted to a datetime value, a runtime error is generated.
• When date is passed as a string, your PC's regional settings are used for the conversion to datetime. If that fails, you get a runtime error.