Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

microsoft sql server extract hour and minute from datetime

datepart    ***Abbreviation

year        ***yy, yyyy 
quarter     ***qq, q 
month       ***mm, m 
dayofyear   ***dy, y 
day         ***dd, d 
week        ***wk, ww 
weekday     ***dw, w 
hour        ***hh 
minute      ***mi, n 
second      ***ss, s 
millisecond ***ms 
microsecond ***mcs 
nanosecond  ***ns
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #microsoft #sql #server #extract #hour #minute #datetime
ADD COMMENT
Topic
Name
8+6 =