f



Time Of Day From a time

Anyone know how to calulacute the time of day, ie hour 1-24 for a time 
stored in a database, using just a time in a record???

Dennis Mason
N6PDB
dennis@bonnydoonfire.org


0
shit9017 (1)
4/12/2006 11:28:11 PM
comp.databases.ms-access 42670 articles. 0 followers. Post Follow

1 Replies
1304 Views

Similar Articles

[PageSpeed] 8

shit wrote:
> Anyone know how to calulacute the time of day, ie hour 1-24 for a time 
> stored in a database, using just a time in a record???
> 
> Dennis Mason
> N6PDB
> dennis@bonnydoonfire.org

If you stored the time value as a DateTime data type, you can display it 
in 24hr time using the Format() function:

   Format(time_column,"hh")

In Debug window:

   ? format(now(),"hh")
     19

Now() is 4/12/2006 7:01:11 PM.   1900 = 7PM.

-- 
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
0
me2968 (1474)
4/13/2006 2:02:00 AM
Reply: