Topics:
DVR
nvrec
Mplayer
Links
Misc
Commands
Humor
New user
uploaded files
|
(links)-> (Parent)->SQL how to select records according to the Hour of Date |
submited by Russell Wed 21 Dec 05 |
SQL command to select records according to the Hour of Date ?
SELECT fields from table where DATE_FORMAT(datefield,"%H")=desired hour
Will select all records from the database with with the desired hour of day.
This message is in responce to a hit from this
search
|
Add comment or question...:
|