Convert Datetime to other format

  • This would be helpful... Thanks

  • FYI - your offsets are incorrect here.  Eastern Time is currently set to -04:00 and Central European (summer time) is set to +02:00.  The expected output you have is correct - but would not be correct if you are use -05:00 as your time zone offset.

    I would also recommend not sending a string date in any of the known ambiguous formats.  Instead - you should be sending the data using the ISO standard format YYYY-MM-DDTHH:MM:SS[+-]hh:mm.  Using this format guarantees that the receiver interprets the date and time appropriately and does not try to convert DD/MM/YYYY to MM/DD/YYYY and fails.

    If you sent the data as 2022-06-14T21:06:00.0000000-04:00 there would be no mistaking exactly what that date/time is - and they can easily convert it to the appropriate local time.

    Jeffrey Williams
    Problems are opportunities brilliantly disguised as insurmountable obstacles.

    How to post questions to get better answers faster
    Managing Transaction Logs

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply