Need to pick 3pm records only

[Anonymous]

I have "timestamp" data and I need to 1)pick only 3 pm and 4 pm between data.

                                        2)only 3 pm data .when I reload.

below attachment have data

[petter]

You can try this:

LOAD
*
FROM <........>
WHERE
  Time(import_date) >=  '15:00' AND Time(import_date) < '16:00';

Replace <.......> with your Excel file specification....

[its_anandrjs]

Try this way also

Load

Complaint_no,

import_date,

parcol

From Source

Where  Right(import_date,5) = '15:00';

[Anonymous]

thanks for reply me

[Anonymous]

thank you for reply me