Second

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 may be used in VBA or in an SQL query.

Examples

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

Related:

Day - Return the day of the month.
Minute - Return the minute of the hour.
Hour - Return the hour of the day


© Copyright SS64.com 1999-2014
Some rights reserved