separate date from time

2 Ansichten (letzte 30 Tage)
huda nawaf
huda nawaf am 26 Jul. 2012
hi,
i have timestamp in my data
such as:
874965478
which contains date and time
what I need is separate date from time
I try this
d=datestr(874965478/86400 + datenum('1/1/1970'))
and get
d =
22-Sep-1997 21:57:58
this result do not what i need, i want the timestamp remain integer but without time just date
can do that?

Melden Sie sich an, um diese Frage zu beantworten.

Akzeptierte Antwort

per isakson
per isakson am 26 Jul. 2012
Bearbeitet: per isakson am 26 Jul. 2012
The function, floor, does it:
>> floor( 874965478/86400 + datenum('1/1/1970') )
ans =
729655
and check the result
>> datestr( ans, 31 )
ans =
1997-09-22 00:00:00
>>
This, 729655, is serial date number.

Weitere Antworten (1)

Star Strider
Star Strider am 26 Jul. 2012
Alternatively, change:
d=datestr(874965478/86400 + datenum('1/1/1970'))
to:
d=datevec(874965478/86400 + datenum('1/1/1970'))
then:
d_date = d(1:3)
This gives you the date as a [YYYY MM DD] vector. You can format it as you like as a string with ‘sprintf’ or other functions.
  4 Kommentare
2 ältere Kommentare anzeigen
huda nawaf
huda nawaf am 29 Jul. 2012
hi again,
why when I used this timestamp: 9783021091
and use d=datestr(9783021091/86400 + datenum('1/1/1970')); get 05-Jan-2280 09:51:31
while when use d=datestr(874965478/86400 + datenum('1/1/1970'))
get d =
22-Sep-1997 21:57:58
thanks
per isakson
per isakson am 29 Jul. 2012
Bearbeitet: per isakson am 29 Jul. 2012
You write: "Why", but doesn't say why you question the result.
Your timestamps are seconds after 1/1/1970(?)
In the second case the integer, 874965478, corresponds to approx. 27 years. In the first case the integer, 9783021091, is eleven times larger, i.e. 300 years. The results is plausible.

Melden Sie sich an, um zu kommentieren.

Kategorien

Mehr zu Time Series Objects finden Sie in Help Center und File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by