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!
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.
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.
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
May 20, 2018 at 11:17 pm - Permalink
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
May 22, 2018 at 05:00 pm - Permalink