Re: Calculated Time Field

Mehmet:

I posted an example of how to script time differences here:
http://rekall.no-no-badpuppy.com/modules/newbb/viewtopic.php?topic_id=8&forum=2&post_id=22#forumpost22

I used python's timedelta function after parsing the time values. There doesn't 
seem to be a really easy way to do this, and like Mike says, it's 
database-dependent.

KD

----- Original Message -----
From: Mike Richardson <mike-1gTsUfBLqWsG2Il/BtU0GPXRex20P6io@xxxxxxxxxxxxxxxx>
Date: Monday, June 20, 2005 5:28 am
Subject: Re: [Rekall] Calculated Time Field

> On Saturday 18 June 2005 13:06, Mehmet Seckiner wrote:
> > Hi!
> >
> > I'm using it and I am happy to find it.
> >
> > I have two time fields come from the same table. I want to show 
> to the
> > operator the difference between these time values. (How much 
> time is passed
> > between the two) SQL supports this kind of an expression: TimeA -
> TimeB
> > But I enter the expression above to the FIELD' s DISPLAY 
> EXPRESSION area it
> > shows me a big number like 120000 when the time expressions are 
> 22:00 and
> > 10:00. I set the format to "Time: %H:%M" but now the output is: 
> Time?120000
> You'll need to do this at the database level.  The result of an 
> expression 
> like (TimeA - TimeB) will be dependant on the database. I'm 
> guessing that in 
> your case the result is a number, seconds maybe?
> 
> >
> > On the other hand if we assume I solved this problem it will not 
> be a
> > complete solution. Because the operator have to see the time 
> between the
> > two entered values before he posts the data to the database.
> >
> > It is seem like a scripting or macro problem.
> >
> > If so, can you describe me how to solve this and lead me into 
> some basic
> > scripting?
> 
> -- 
> Regards
> Mike
> 
> http://www.rekallrevealed.org
> *THE* GPL/Open Source database front end for Linux and Windows.
> 
> _______________________________________________
> Rekall mailing list
> Rekall-TvUNdCdnGOiN0BpGcQGnph2eb7JE58TQ@xxxxxxxxxxxxxxxx
> http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall
>