Separate date and time

34 visualizzazioni (ultimi 30 giorni)
MatLab Code N
MatLab Code N il 21 Set 2021
Commentato: MatLab Code N il 22 Set 2021
I have the datetime in a column as given in an attached example excel sheet. Between date and time there is an alphabet T. Can I get a help to seperate out date and time.
Thanks!

Risposte (1)

Steven Lord
Steven Lord il 21 Set 2021
dt = datetime('now') % Sample data
dt = datetime
21-Sep-2021 19:44:52
theTime = timeofday(dt)
theTime = duration
19:44:52
theDate = dt - theTime % or
theDate = datetime
21-Sep-2021
theDate2 = dateshift(dt, 'start', 'day')
theDate2 = datetime
21-Sep-2021
  2 Commenti
MatLab Code N
MatLab Code N il 21 Set 2021
I have also attached the example datetime along with the question. How can I make this work for my data?
MatLab Code N
MatLab Code N il 22 Set 2021
@Steven Lord any help is highly appreciated sir!

Accedi per commentare.

Categorie

Scopri di più su Time Series Objects in Help Center e File Exchange

Tag

Prodotti


Release

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by