BusinessObjects Board

time between 2 times (duration)

building semantic layer
#1

Hi ,

I have 2 objects: Time-start (HH:MM) en Time-end
Now, I need to know the seconds or minutes between these 2.

Any ideas (Oracle)?

thanks,
Lia

Lia :netherlands: (BOB member since 2004-08-24)

#2

Perhaps this helps:
http://asktom.oracle.com/~tkyte/Misc/DateDiff.html
or this if you’re coming from sql server
http://www.sql-ref.com/

Regards,

Gerard

highandstoned :netherlands: (BOB member since 2005-08-01)

#3

A search on BOB could also be helpfull. Check https://bobj-board.org/t/14563 or https://bobj-board.org/t/48247.

jobjoris :netherlands: (BOB member since 2004-06-30)

#4

so the general consensus is: search before you post :!:

or is your object not a datetime type ?

regards,

Gerard

highandstoned :netherlands: (BOB member since 2005-08-01)

#5

Character… lenght = 4

lia

Lia :netherlands: (BOB member since 2004-08-24)

#6

Still, if you did a little search on BOB you could for instance have run into https://bobj-board.org/t/21735. This should get you on the right track.

jobjoris :netherlands: (BOB member since 2004-06-30)

#7

datetime’s stored in text…and just hh:mm…nice if you run over a day limit…what’s the world going to… :crazy_face:

Well follow the work jobjoris has done for you…and if you have any problems after that, feel free to post your problem… :wink:

Regards,

Gerard

BTW: nice to have an all dutch post…

highandstoned :netherlands: (BOB member since 2005-08-01)

#8

Well, since the thread posts were all made between about midnight and 6am my time, it’s probably due to time zone! :rotf: :wink:

Anita Craig :us: (BOB member since 2002-06-17)