SQL SECOND() Function

SQL SECOND() Syntax

The below syntax is used to get second of the SECOND value (a integer number between 0 to 59, inclusive) from a given input datetime value.

For SQL SERVER / MY SQL / MS ACCESS

SELECT SECOND('valid_datetime_value' or 'valid_timestamp_value');

SQL SECOND() Example - Using Expression Or Formula

The following SQL SELECT statement will extract the second of the SECOND value from a given input datetime value. We use now() function to get the input date value.

SELECT 
NOW() AS 'Current Date and Time', 
SECOND(NOW()) AS 'Second Value';

The result of above query is:

Sample Database Table - BookOrder

SQL SECOND() Example - With Table Column

The following SQL SELECT statement display the column "OrderDate" and "DeliveryDate" from the "BookOrder" table. The SECOND() function will extract the SECOND value(a whole integer number from 1 to 60) from the column "OrderDate" and we will stored that value to a new column called "Order SECOND" and "Delivery SECOND".

SELECT 
OrderDate, SECOND(OrderDate) As 'Order SECOND', 
DeliveryDate, SECOND(DeliveryDate) As 'Delivery SECOND' 
FROM BookOrder;

The result of above query is: