Rob Fitzpatrick
ProgressTalk.com Sponsor
Yes, I know that's a confusing thread title. 
I'm trying to parse fields like _DbStatus-starttime or _Connect-time, e.g. to be able to apply a format string to get just the time portion or just the date portion. But it turns out they're not datetime fields, they're character (display format "x(24)"). Output looks like: Fri Jul 26 13:56:53 2013.
I found some code that Tom wrote for dealing with such fields, in protop3/lib/protoplib.p. I suppose the existence of this code answers my question, but is there no simpler way of dealing with these strings?
Bonus question: why didn't PSC use date fields? Is it because they wanted a date and time in one field, and the fields were added to the meta-schema prior to the existence of datetime and datetime-tz?
I'm trying to parse fields like _DbStatus-starttime or _Connect-time, e.g. to be able to apply a format string to get just the time portion or just the date portion. But it turns out they're not datetime fields, they're character (display format "x(24)"). Output looks like: Fri Jul 26 13:56:53 2013.
I found some code that Tom wrote for dealing with such fields, in protop3/lib/protoplib.p. I suppose the existence of this code answers my question, but is there no simpler way of dealing with these strings?
Bonus question: why didn't PSC use date fields? Is it because they wanted a date and time in one field, and the fields were added to the meta-schema prior to the existence of datetime and datetime-tz?
