DekGenius.com
Home
(current)
Dictionary
BOOKS
LYRICS
CHORD
SCRIPT & CODE EXAMPLE
Karaoke language
Search
Go
SCRIPT & CODE EXAMPLE
CODE EXAMPLE FOR SQL
mysql get time from datetime
SELECT
date_format
(
datecol
,
'%H:%i:%s'
)
as
'time'
FROM
table
;
-- eg. 10:33:10
PREVIOUS
NEXT
Tagged:
#mysql
#time
#datetime
ADD COMMENT
Topic
COMMENT
Name
7+2 =
Submit