Home page
 
 Home 
 ASP 
 PHP 
 SQL 
 HTML 
 JavaScript 
 Search 
 Contact 
 
Search
or browse popular tags
Access Functions
Subscription

Sign up for the free email newsletter for new tips, tutorials and more. Enter your email address below, and then click the button.

Privacy Policy

RSS Twitter

Access: TimeSerial Function

Print

In Access, the TimeSerial function returns the time for a specific hour, minute, and second.

The syntax for the TimeSerial function is:

TimeSerial ( hour, minute, second )

The TimeSerial function returns a time that is stored internally as a double-precision fractional number between 0 and 0.99999. This number represents a time between 0:00:00 and 23:59:59, or 12:00:00 A.M. and 11:59:59 P.M., inclusive. If the time specified by the three arguments, either directly or by expression, falls outside the acceptable range of times, an error occurs.

hour is a number between 0 (12:00 A.M.) and 23 (11:00 P.M.), inclusive, or a numeric expression.

minute is a number between 0 and 59, inclusive, or a numeric expression.

second is a number between 0 and 59, inclusive, or a numeric expression.

Examples

TimeSerial (15,3,24)        returns 3:03:24 PM
TimeSerial (11,-5,24)       returns 11:55:24 AM
TimeSerial (10,39-5,43)     returns 10:34:43 AM

VBA Code

Dim MyTime As Date
MyTime = TimeSerial(15,3,24)

This example uses the TimeSerial function to return a time for the specified hour, minute, and second. Now the MyTime variable would contain the value of '3.03.24 PM'.

SQL query

You can also use the TimeSerial function in a query.

SELECT TimeSerial(10,48,21) AS Expr1
FROM Orders


If you'd like to see how it works, enter SQL statement and press Execute
 




Tags:

Add To: Add to dzone dzone | Digg this digg | Add to del.icio.us del.icio.us | Stumble it stumbleupon

  • Comments





Copyright © 2005-2014             www.WebCheatSheet.com All Rights Reserved.