Date and time format question

[Paul Dupuis]

Thanks! You math to do the offset is much simpler.

On 7/29/2024 6:34 PM, Bob Sneidar via use-livecode wrote:
> Meh never mind overthinking it. Both ways work.
>
> Bob S
>
>
>> On Jul 29, 2024, at 3:30 PM, Bob Sneidar <bobsneidar at iotecdigital.com> wrote:
>>
>> Actually it’s possible in some whacko time zones to get a rounding error by dividing first so:
>>
>> …
>>> put (tOffset *60 *60) /100 into tOffset
>> …
>>
>> Bob S
>>
>>
>>> On Jul 29, 2024, at 3:14 PM, Bob Sneidar via use-livecode <use-livecode at lists.runrev.com> wrote:
>>>
>>> Simpler than that:
>>>
>>> on mouseUp
>>>   put "Mon, 29 Jul 2024 15:49:52 -0400" into tDateTime
>>>   put word -1 of tDateTime into tOffset
>>>   -- delete last word of tDateTime
>>>   convert tDateTime to seconds
>>>   put (tOffset / 100) *60 *60 into tOffset
>>>   add tOffset to tDateTime
>>>   convert tDateTime to  long date and  long time
>>>   put tDateTime
>>> end mouseUp
>>>
>>> Bob S
>>>
>>>
>>>> On Jul 29, 2024, at 3:02 PM, Paul Dupuis via use-livecode <use-livecode at lists.runrev.com> wrote:
>>>>
>>>> dateItems does not contain the timezone offset, so you would need to get the timezone offset from the internet date (the only format I can find that has it) and the break the offset into minutes and hours and perform the math.
>>>>
>>>> I haven't tested this code (yet), but I think the seconds is the way to go.
>>>>
>>>> function refiXMLTimestamp
>>>> -- Need to return the timestamp (current time) in UTC format, or YYYY-MM-DDTHH:MM:SSZ where Z is zulu or GMT
>>>> local tTimestamp
>>>> get the internet date -- Mon, 29 Jul 2024 16:49:52 -0400
>>>> -- the day of the week followed by a comma, all other item delimited by a space
>>>> -- the day of the month
>>>> -- the three-letter abbreviation for the month name
>>>> -- the four-digit year
>>>> -- the time in 24-hour format, including seconds, delimited by colons
>>>> -- the four-digit time zone relative to UTC (Greenwich) time
>>>> set the itemDel to space
>>>> put last item of it into tZoneOffset -- +/-hhmm
>>>> set the itemDel to comma
>>>> convert it to seconds
>>>> -- the year
>>>> -- the month number
>>>> -- the day of the month
>>>> -- the hour in 24-hour time
>>>> -- the minute
>>>> -- the second
>>>> -- the numeric day of the week where Sunday is day 1, Monday is day 2, and so forth
>>>> put    char -1 to -2 of tZoneOffset into tMinOffset
>>>> delete char -1 to -2 of tZoneOffset
>>>> put ((tZoneOffset*3600)+(tMinOffset*60)) into tSecOffset
>>>> -- adjust time to zulu/gmt
>>>> add tSecOffset to it
>>>> convert it to dateItems
>>>> -- Now convert to YYYY-MM-DDTHH:MM:SSZ where Z is zulu of GMT/UTC
>>>> put format("%4u",item 1 of it) &"-"& format("%2u",item 2 of it) &"-"& format("%2u",item 3 of it)           into tTimestamp -- the date in new format
>>>> put "T"& format(%2u",item 4 of it) &":"& format("%2u",item 5 of it) &":"& format("%2u",item 6 of it) &"Z" after tTimestamp -- the time in new format
>>>> return tTimestamp
>>>> end refiXMLTimestamp
>>>>
>>>> On 7/29/2024 5:37 PM, Bob Sneidar via use-livecode wrote:
>>>>> Convert it to dateitems, then back again.
>>>>>
>>>>> Bob S
>>>>>
>>>>>
>>>>>> On Jul 29, 2024, at 2:09 PM, Paul Dupuis via use-livecode <use-livecode at lists.runrev.com> wrote:
>>>>>>
>>>>>> Follow up question/request:
>>>>>>
>>>>>> put the internet date into tTimestamp -- stores something like Mon, 29 Jul 2024 16:49:52 -0400, where the -0400 is the time zone offset
>>>>>>
>>>>>> Anyone have some already written code to convert this to a time in GMT (i.e where the time zone offset is +0000, i.e. Mon, 29 Jul 2024 20:49:52 +0000)?
>>>>>>
>>>>>> It is adding the offset to the hours and minutes, but you have to handle carry over, potentially adding or subtracting a day.
>>>>>>
>>>>>> If the best approach converting to seconds and the doing the math and converting back? (I think this is the answer)
>>>>>>
>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> use-livecode mailing list
>>>>>> use-livecode at lists.runrev.com
>>>>>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>>>>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>>>> _______________________________________________
>>>>> use-livecode mailing list
>>>>> use-livecode at lists.runrev.com
>>>>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>>>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>>>
>>>> _______________________________________________
>>>> use-livecode mailing list
>>>> use-livecode at lists.runrev.com
>>>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>>
>>> _______________________________________________
>>> use-livecode mailing list
>>> use-livecode at lists.runrev.com
>>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-livecode
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode