डाउनलोड पी.डी.एफ. ई-बुक्स
SQL - SECOND

SECOND() DATE/TIME Function दिए गए date से second(0 to 59) को return करता है |


Syntax for SECOND() DATE/TIME Function in SQL

SECOND(date/datetime)

Parameter :

date/datetime : यहाँ पर date दी जाती है |


Example for SECOND() DATE/TIME Function in SQL

Source Code :
SELECT SECOND("2016-05-26 03:25:57");
Output :
+-------------------------------+
| SECOND("2016-05-26 03:25:57") |
+-------------------------------+
|                            57 |
+-------------------------------+

Another Example for SECOND() DATE/TIME Function in SQL

Source Code :
SELECT SECOND("03:25:57");
Output :
+--------------------+
| SECOND("03:25:57") |
+--------------------+
|                 57 |
+--------------------+