Time Of Day From a time

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sh.t - 13 Apr 2006 00:28 GMT

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

Reply to this Message

MGFoster - 13 Apr 2006 03:02 GMT

> 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.

Signature

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

Reply to this Message