Return the seconds of the minute (a number from 0 to 59) for a given time value.
Syntax Second(time_value) Key time_value A valid time.
The Second() function can be used in VBA or in an SQL query.
Dim intDemo as integer
intDemo = Second(dtmShiftEnd)
intDemo = Second(#08:55:30 AM#)
Select * from orders where Second(Order_date) = 30;
“For a moment, nothing happened. Then, after a second or so, nothing continued to happen” ~ Douglas Adams
Day - Return the day of the month.
Minute - Return the minute of the hour.
Hour - Return the hour of the day