RE: [sqr-users] Adding minutes to date time field

["Lynds,Rick" <rlynds@mwdh2o.com>]

Abhay,

It depends on how complex you want to make the query....You could try
something like

nvl(a.stop_time,a.strt_time + (decode(xxx.full_part_time, 'F', 45,
15)/1440))  &stop_time=date

Assuming that you are using Oracle and xxx is a table that is included in
the query that finds a field that indicates full ("F") or part ("P") time.

Rick

-----Original Message-----
From: abhay sachar [mailto:sachar_abhay@hotmail.com]
Sent: Friday, March 26, 2004 9:24 AM
To: sqr-users@sqrug.org
Subject: Re: [sqr-users] Adding minutes to date time field


Hi Don,

That works perfectly, but my problem is that I have to look at another field

-
to determine if I have to add 15 min. or 45 min. to start time.

If Employee is full time, add 45 min. to start time and assign to stop time
If Employee is part time, add 15 min. to start time and assign to stop time

I guess we cannot have this thru the Select query.

I am sorry I did not mention it in the earlier note.

-Abhay.

<snip>

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users