Results 1 to 2 of 2

Thread: Timing Identify

  1. #1
    Join Date
    Mar 2007
    Posts
    3

    Unanswered: Timing Identify

    Hi
    I work in HRM Software. So I have to handle Worker Entry and Exit timing.
    Such one worker Entrance 23/04/07 8.00 am and exit 18.00 pm again other shift entry 23/04/07 19.00 pm and exit that employee 24/04/07 7.00 am .
    How can i findout 2nd shift timing. can you help me.
    I work in oracle 9i . Thanks for reply.

    Jahid

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    The same way you'd do that for the first shift: subtract EXIT and ENTRY time. The result is number of days. If you are interested in hours / minutes, you'll have to do a little calculation (for example: for hours, multiply the result by 24 (number of hours in a day). As you didn't specify what you, actually, need, here is the beginning; now you have something to start with.
    Code:
    SQL> l
      1  select to_date('24.04.2007 07:00', 'dd.mm.yyyy hh24:mi')
      2       - to_date('23.04.2007 19:00', 'dd.mm.yyyy hh24:mi') time_diff
      3* from dual
    SQL> /
    
     TIME_DIFF
    ----------
            .5
    
    SQL>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •