[Kst] Reading formatted dates and mixing with ctimes

[Nicolas Brisset]

Hi David,

Your use case sounds like an interesting test for the support of string-formatted time in ASCII files. I guess you're using a recent 2.0.7 snapshot, right?
It would be helpful if you could post some samples or screenshots. Is that possible?

Nicolas

----- Mail original -----
> De: "David McMinn" <david.mcminn at iwcdownhole.com>
> À: "kst at kde.org" <kst at kde.org>
> Envoyé: Jeudi 27 Juin 2013 16:27:18
> Objet: [Kst] Reading formatted dates and mixing with ctimes
> 
> Hi,
> 
> I have two separate data files, both ASCII, both time/value. They are
> not sampled or aligned in the time axis. I'd like to be able to plot
> them in two separate plots but have their zoom tied so that I can
> visually see the corresponding data.
> 
> The first data set has the time in seconds since the UNIX epoch, so
> I'm reading that in interpreting the column as C Time. This is fine.
> 
> The second data set has the time formatted as "dd/MM/yy-hh:mm:ss", so
> I read that in as a formatted time with the above format string.
> That also seems to read in OK. The values I get are in the range
> 178458000 + 6e4, corresponding to date/times in the range 13 June
> 2013 23:00:00 to 15 June 2013 02:16:30. I don't know if that's right
> as I'm not sure what the QDateTime representation is.
> 
> Now the problems start. Whatever I set my X axis "interpret as"
> setting to I cannot get the date/time for the second data file to be
> displayed as a date/time that is displayed "sensibly", such as
> 13/06/2013 23:00 with the additional time in square brackets, as KST
> does for C Time. The closest I can get is interpreting it as a C
> Time and displaying with a custom format string of "dd/MM/yy
> hh:mm:ss" otherwise it seems to have picked the date up as 1913,
> which I guess is because 1.78e9 loops round to 1913. This obviously
> stops the tied zoom from working.
> 
> Other interpretations end up with the above 1.78e9 numbers or
> 12:00:00 with spans of hundreds or thousands of years.
> 
> What's the best way to read in a formatted time and have it displayed
> as a timestamp?
> 
> Is it possible to align two plots on date/time rather than the
> numerical value of their timestamp?
> 
> Thanks.
> 
> 
> _______________________________________________
> Kst mailing list
> Kst at kde.org
> https://mail.kde.org/mailman/listinfo/kst
>