Comparing Time elements of dates

[b][red]This message was edited by anrice at 2004-3-15 7:49:1[/red][/b][hr]
I want to check the time element of a date entered against the
a field that stores the Working Day Start Time to see if the time element of the date entered precedes or is after the Day Start Time.

I can currently do this using datediff and playing around with date calculations but what is the easiest way to do so?

The code I am currently using is along the lines of:

:
declare @dat_starttime as datetime,
@dat_to as datetime,
@int_interval as dec (7,5)

SELECT @dat_starttime = '14:00', @dat_to = '15-mar-2004 13:15'

select @int_interval = datediff(minute,@dat_starttime, @dat_to - datediff(day,@dat_starttime,@dat_to))
print @int_interval
:

Regards
anrice


Comments

  • : [b][red]This message was edited by anrice at 2004-3-15 7:49:1[/red][/b][hr]
    : I want to check the time element of a date entered against the
    : a field that stores the Working Day Start Time to see if the time element of the date entered precedes or is after the Day Start Time.
    :
    : I can currently do this using datediff and playing around with date calculations but what is the easiest way to do so?
    :
    : The code I am currently using is along the lines of:
    :
    : :
    : declare @dat_starttime as datetime,
    : @dat_to as datetime,
    : @int_interval as dec (7,5)
    :
    : SELECT @dat_starttime = '14:00', @dat_to = '15-mar-2004 13:15'
    :
    : select @int_interval = datediff(minute,@dat_starttime, @dat_to - datediff(day,@dat_starttime,@dat_to))
    : print @int_interval
    : :
    :
    : Regards
    : anrice
    :
    :
    :


    if all your doing is checking to see if one date is greater then the other, then you should be able to do it directly, as in:
    if date1 > date2 .....


    [blue]
    C:Dos
    C:Dos Run
    Run Dos Run
    [/blue]

  • I'm not comparing dates at all.

    The system has a setting for StartTimeOfDay which indicates the working start time.

    I need to take the time element of the actual transaction date and compare the time element to the StartTimeOfDay.

    Regards
    anrice
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories