Home/ Questions/Q 4471
In Process

vinish.ai Latest Questions

  • 0
  • 0
Asked: 2021-01-11T10:14:34+00:00

Extract Date & Time form finger print machine

  • 0
  • 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
Share
Leave an answer

Leave an answer

Browse

4 Answers

  1. 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;