correct representation for only time

Share icon

Sun, 05/20/2018 - 09:37 am

Hello, wondering what would be the correct format (in general) if I only want to specify 00:00:00 in a wave. I want to pick out from a time series only data points at the midnight and want to create a conditional statement, but don't know how to pick out the 00:00:00 timestamps. Any help? Thanks!
Hi,

Date time is really a numeric with the DateTime function returns number of seconds from 1/1/1904 to the current local date and time. Starting at midnight,00:00:00. So each day would be a multiple of (24*60*60).

You can use date2secs(year, month, day ) to get the value at 00:00:00 for a given day.


Andy

May 20, 2018 at 09:52 am - Permalink

Thank you hegedus! My question is more about using a value to specify midnight for a consecutive days. So far I have tried condensing the seconds from 1941 to a two-digit number representing the hour, and pick the 0. It works for now, but still curious what would be an elegant way to specify 00:00:00.

May 20, 2018 at 11:17 pm - Permalink

Not sure I quite understand the question, but if you want only the data from midnight, you could do something like this:

Extract timewave, timewave_midnight, (mod(timewave,86400)==0)

to get the times at midnight, and similarly with your data wave.

Extract datawave, datawave_midnight, (mod(timewave,86400)==0)

Ken

May 21, 2018 at 08:17 am - Permalink