OraFAQ Forum: Forms » adding time in mins to given time(entered by user)

Home » Developer & Programmer » Forms » adding time in mins to given time(entered by user)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

adding time in mins to given time(entered by user) [message #87786]

Fri, 11 February 2005 04:29

subbalakshmi
Messages: 1
Registered: February 2005

Junior Member

i want to add 20 mins to a text box value(in the format hh24mi) and to be displayed ,
in other text box with same format

Report message to a moderator

Re: adding time in mins to given time(entered by user) [message #87787 is a reply to message #87786]

Fri, 11 February 2005 05:06

Frank
Messages: 7901
Registered: March 2000

Senior Member

In date calculations, 1 unit stands for 1 day. So:

add 1 day => + 1
add 1 hour => + 1 / 24
add 1 minute => + 1 / (24 * 60)
add 1 second => + 1 / (24 * 60 * 60)
add 1 week => + 7
add 1 month => add_months(date, 1)
add 1 year => add_months(date, 12)

hth

Report message to a moderator

Previous Topic:	Translation builder
Next Topic:	Developer2000 Forms DLL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 16 16:45:12 CDT 2024