Hour(), Minute(), Sec()
These functions extract the hour, minute and second portions of a datetime value. Backward compatibility with previously existing functions makes for some funny, non-intuitive abbreviation rules. Usage | nHours = HOUR( tDateTime ) nMinute = MINUTE( tDateTime ) nSeconds = SEC( tDateTime ) |
Example | ? "The time is now " + LTRIM(STR(HOUR(DATETIME()))) + ; " hours, " + LTRIM(STR(MINUTE(DATETIME()))) + ; " minutes and " + LTRIM(STR(MINUTE(DATETIME()))) + ; " seconds past midnight" |
See Also | Date(), DateTime(), Min(), Seconds(), Set Hour |
View Updates
Copyright © 2002 by Tamar E. Granor, Ted Roche, Doug Hennig, and Della Martin. All Rights Reserved.