Post reply

Last working day

  • June 6, 2012 at 8:47 am

    #257290

    HI,

    I'm new to PL/SQL. Please help me.

    select COUNT(*) from table1 where trunc(tradeDone) >= trunc(sysdate)-1;

    In this query I want to subtract sysdate-3 if sysdate is Monday.

    Basically in the where clause I should compare tradeDone greater or equal to last working day. Kindly note no bank holidays needs to be considered. So if sysdate is Monday I have to point to friday and count the number of rows.

    Please help

    Thanks

    Regards

    Jim

  • June 6, 2012 at 8:53 am

    #1497676

    You do know that 1) SQLServerCentral.com is a site whose focus is Microsoft SQL Server and 2) you posted this is a SQL Server 2005 Integration Services forum.

    You may not get much of an answer here. I haven't worked with PL/SQL in over 6 months, and what I do remember isn't much since I only worked with it for a year.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply