UDT to handle DateTimeZone data
Allan Ferreira asked for a UDT to store timestamps like 2018-04-19T02:14:09.089473705-07:00 with a time zone, from a Tesla Powerwall 2. Fernando Nunes knew of none; he had tried a derived GMT type but concluded C was needed for casts. Paul Watson said it would be a simple C wrapper around mi_string_datetime. No ready-made type was provided.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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.
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...
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'")
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