Home Forums SQL Server 2005 SQL Server 2005 Integration Services Possible to determine the datetime range of loaded data to staging table? RE: Possible to determine the datetime range of loaded data to staging table?

  • December 28, 2012 at 12:33 am

    #1572021

    Here's my pseudo-code expanded a bit to accommodate the start and end date bits:

    declare @StartDate datetime

    ,@EndDate datetime

    set @EndDate = dateadd(hour, 8, DATEADD(dd, 0, DATEDIFF(dd, 0, DATEADD(HOUR, - 8, getdate()))))

    set @StartDate = dateadd(hour, - 73, @EndDate)

    select col1

    ,col2

    from table

    where [convert varchar date and time to datetime] between @StartDate

    and @EndDate

    That's how it works in T-SQL. Just need to convert that to Oracle.

    --Edit: fixed typo.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.