Tech Tip: Julian Days Format
Tech Tip: Julian Days Format
“Julian Days” is a numerical timestamp format, calculated by Sea-Bird Scientific CTDs as the number of the days since Jan 1 of that year (e.g., noon on Feb 3 = 34.5). While this format is useful, it is usually more convenient to display data in a visual format such as “2020-02-03 12:00:00″. Learn how to convert Julian Days to standard formats using tools like SBEDataProcessing, Excel, and Matlab.
Exporting “Time, Elapsed: Julian Days” from CTD data provides a count of days since Midnight on Jan 1 of that year, as referenced to the CTD’s timestamp. Some examples:
- Midnight on January 1st: timeJ = 1
- Midnight on January 2nd: timeJ = 2
- Midnight on February 1st: timeJ = 32
- Noon on February 1st: timeJ = 32.5
To convert to a standard time format with a deployment starting in 2020
- Sea-Bird Data Processing: Use Time conversion in ASCII out
- In Excel: 1/1/2020+timeJ-1
- In matlab: datenum(2020, 1, 1)-1+timeJ
- In Python: d = datetime.date(dyear, 1, 1) + datetime.timedelta(yday – 1)
- In R: time1 <- ISOdatetime(year, 1, 1, 0, 0, 0, tz=’UTC’) + (jday – 1)*86400
However, beware that the timeJ is referenced against the timezone of the instrument which can either be local or UTC
# start_time = Feb 25 2019 12:00:01 [Instrument’s time stamp, first data scan]
Related Posts
Featured Posts
2024 MTS Buoy Workshop
We are excited to exhibit at the upcoming MTS Buoy Workshop this year from May 20 - 23. Please come visit us in our backyard at table #1 to chat with our team to learn more about the latest at Sea-Bird Scientific and oceanography. We'll have associates from...
Case Study: Understanding the Implications of the Lahaina Wildfire on Coastal Water Quality with the HydroCAT-EP V2
Contributors: Dr. Andrea Kealoha (she/her)¹, Natalie Zielinski (she/her)², Marialena Christopoulou (she/her)² Authors: Lindsey Biondo (she/her)², Natalie Zielinski (she/her)² ¹ University of Hawai’i at Mānoa, Department of Oceanography, 1000 Pope Road, Honolulu, HI...
Webinar on Fathom Software in Partnership with the Marine Technology Society
We were excited to partner with the Marine Technology Society (MTS https://www.mtsociety.org/) to bring you a webinar to walk through our new software. We’re excited to release Fathom – the latest in software innovation at Sea-Bird Scientific (SBS). Heather Eberhart,...