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 <bobsnei...@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@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@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@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@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@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@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@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@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
