Home/Questions/Q 4471
In Process
Bheem
Bheem

Bheem

View Profile
  • 0
Professional
Asked: 2021-01-11T10:14:34+05:30

Extract Date & Time form finger print machine

  • 0

Hi Sir,

how to extract date & time , emp id from this column. this is output from fingerprint machine. to track emp attendance.

080121161350 00000001

I want output :

Date & Time :08-01-21 16:13:50

Emp : 00000001

oracle apex

    4 Answers

    1. Vinish

      Vinish

      View Profile
      Legendary

      There is a space between two values, you can extract on this behalf. Below is an example:

      Declare
  v_whole_string varchar2(100);
  v_date varchar2(50);
  v_empid varchar2(50);
  d_date date;
Begin
  v_whole_string := '080121161350 00000001';
  v_date := substr(v_whole_string, 1, instr(v_whole_string, ' ')-1);
  v_empid := substr(v_whole_string, instr(v_whole_string, ' ')+1);
  d_date := to_date(v_date, 'ddmmyyhh24miss');
  dbms_output.put_line(v_date);
  dbms_output.put_line(v_empid);
  dbms_output.put_line(d_date);
End;
      • 0

    You must login to add an answer.