In an attempt to standardize my handling of formatting timestamps as text, I have added functions to "JDP Science Common Utilities" (a VI support package, on the Tools Network). This is used by SQLite Library (version just released) and JSONtext (next release), but they can also be used by themselves (LabVIEW 2013+). Follows RFC3339, and supports local-time offsets.
By Phillip Brooks
My new job has me starting from scratch DB wise. I worked with a homegrown schema for many years, but it doesn't match my needs here and I want to make this supportable log term (next poor soul), so I was thinking of using the out-of-box schema with MySQL.
I've got MyQL 5.1 and TS 2010 installed; the TS 2010 MySQL implementation uses INSERT statements which lack my one pet peeve, a timestamp data type. I think this may be because MySQL at the time 2010 was developed only had a date-time data type.
Does anyone know if a newer version of TestStand includes support for a timestamp data type with the MySQL template?
By Bjarne Joergensen
I need the UTC time and convert it to tics.
I use this code(LV2012/DotNet 2.0):
Why is the Now time(local) the same as UTCtime. There should be a difference of 2 hours!
I made a program in C# and it is showing the right time (2 hours between Local and UTC)
I'm plotting a bar graph which takes only double data input.
My X-axis should be the timestamp and my Y-axis is the double data.
Bt here I can't figure out any way to convert the timestamp to double so that I can use it as an input.