Comparing Time elements of dates - Programmers Heaven

Howdy, Stranger!

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

Categories

Comparing Time elements of dates

anriceanrice Posts: 3Member
[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

  • GideonOmegaGideonOmega Posts: 617Member
    : [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]

  • anriceanrice Posts: 3Member
    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.