data table delete rows after time

2 ビュー (過去 30 日間)
Badr Sahib
Badr Sahib 2017 年 4 月 7 日
コメント済み: Peter Perkins 2017 年 4 月 12 日
I have a largeData as table (imported from oracle database). The first column is timestamp (date and time). How can I delete certain lines after time (timestamp). I want to delete the night data, between 22h and 5h. Or can I change what in SQL command? ...FROM "LOGDATEN".DATENLOGGER_SHA WHERE DATUM >= to_date(''2016-07-01'',''yyyy-MM-dd'') AND DATUM < to_date(''2016-08-01'',''yyyy-MM-dd'')order by datum asc']) thanks for your help
  1 件のコメント
Peter Perkins
Peter Perkins 2017 年 4 月 12 日
Badr, you're going to need to provide a short example so that people can see what you mean by "table" and "timestamp (date and time)".

サインインしてコメントする。

サインインしてこの質問に回答する。

回答 (1 件)

Sid Jhaveri
Sid Jhaveri 2017 年 4 月 10 日
If you would like to do this processing in MATLAB after you have imported the data as a table, you can use " isbetween " function for creating a logical array which states which datetime entry meets the criteria. You can then filter your table by using this logical array.

カテゴリ

Help Center および File Exchange で Data Type Identification についてさらに検索

タグ

製品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by