Hours from a Time feild

RV_18 · 2012-07-07

Hello All,

Can anybody tell me that how can I get the Hours out of a time value. For example out of 22:34, I want 22 to be stored in another variable for further processing.

Thanx in advance,
Ravi Verma

David_Singleton · 2012-07-07

There are many ways, but probably using ROUND or MOD is the easiest eg

Result := round((TimeToConvert-000000T)/3600000 ,1,'<');

mohana_cse06 · 2012-07-07

Welcome to Mibuso

Please use search before posting
http://www.mibuso.com/forum/viewtopic.php?f=23&t=40941&start=0

David_Singleton · 2012-07-07

Thanks Mohana, but I have been here long enough that a "welcome" at this point would be a little bit late.

mohana_cse06 · 2012-07-07

David Singleton wrote:

Thanks Mohana, but I have been here long enough that a "welcome" at this point would be a little bit late.

sorry David,I didnt see your reply..

Welcome is for Ravi Verma

RV_18 · 2012-07-08

Thanks Mohana

RV_18 · 2012-07-08

Thanks David for ur reply

Hours from a Time feild

Comments

Categories