UDT to handle DateTimeZone data

Posted in 2018

ALLAN FERREIRA — Fri, 20 Apr 2018 08:11:48 — source: IIUG Forums & Mailing Lists

Has anyone got a UDT to store and manage this date/time/zone format in Informix directly without having to manipulate the date : 2018-04-19T02:14:09.089473705-07:00 Product Management : Given the global nature of computing and IOT devices that are storing data in the cloud there should be a native data type to hand; DateTimeZone data.

↪ replying to ALLAN FERREIRA

Fernando Nunes — Fri, 20 Apr 2018 08:18:54 — source: IIUG Forums & Mailing Lists

Not that I heard about. But it's something I've imagine would be nice to have considering the globalization. Some time ago I tried to create a derived type that would store the timestamps in GMT format. But I rapidly reach the conclusion that I would need C to do the casts.... And never proceeded with the tests... I don't understand the "format" you provide as an example, but I assume it's a bit different from what I was trying... looks like it contains the timezone definition in the value? Regards. On Fri, Apr 20, 2018 at 10:11 AM, ALLAN FERREIRA <allan.ferreira@gmail.com> wrote: > Has anyone got a UDT to store and manage this date/time/zone format in > Informix directly without having to manipulate the date : > > 2018-04-19T02:14:09.089473705-07:00 > > Product Management : Given the global nature of computing and IOT devices > that > are storing data in the cloud there should be a native data type to hand; > DateTimeZone data. > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...

↪ replying to ALLAN FERREIRA

ALLAN FERREIRA — Fri, 20 Apr 2018 08:29:31 — source: IIUG Forums & Mailing Lists

This is the data I am receiving from Telsa Powerwall 2, looks like the format is : Java SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss'Z'")

↪ replying to ALLAN FERREIRA

Paul Watson — Fri, 20 Apr 2018 11:18:33 — source: IIUG Forums & Mailing Lists

This is just a simple C wrapper to a mi_string_datetime Paul Watson Oninit www.oninit.com Tel: +1 913 674 0360 Cell: +1 913 387 7529 Oninit® is a registered trademark of Oninit LLC Failure is not as frightening as regret. If you want to improve, be content to be thought foolish and stupid. > On Apr 20, 2018, at 03:11, ALLAN FERREIRA <allan.ferreira@gmail.com> wrote: > > Has anyone got a UDT to store and manage this date/time/zone format in > Informix directly without having to manipulate the date : > > 2018-04-19T02:14:09.089473705-07:00 > > Product Management : Given the global nature of computing and IOT devices that > are storing data in the cloud there should be a native data type to hand; > DateTimeZone data. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. --Apple-Mail-629550B0-B62D-4DF8-B819-0AC760E580F6