I had the same issue. I get a date as a String, for example: '2016-08-25T00:00:00', but I need to have the Date object with correct time. To convert String into object, I use getTimezoneOffset:

var date = new Date('2016-08-25T00:00:00')
var userTimezoneOffset = date.getTimezoneOffset() * 60000;
new Date(date.getTime() + userTimezoneOffset);

getTimezoneOffset() will return ether negative or positive value. This must be subtracted to work in every location in world.

Datetime Documentation is actually confusing.

Note:

valueOf: Returns the datetime in GMT timezone
valueOfGmt: Returns the datetime relative to GMT timezone

So, change the code to below:

Datetime today = Datetime.now(); 
String myDate = today.format('yyyy-MM-dd HH:mm:ss');
Datetime myDateTime = Datetime.valueOfGmt(myDate);

System.debug('myDate:: '+myDate );  
System.debug('myDateTime:: '+myDateTime); 

You can use the DateTime property of DateTimeOffset.

Example:

string s = "2013-07-22T08:51:38.000-07:00";
var dateTimeOffset =DateTimeOffset.Parse(s, null);
Console.WriteLine(dateTimeOffset.DateTime); 

Outputs:

22/07/2013 08:51:38

As far as I understood your requirement; you want to convert the timestamp to a date string without timezone, for which you can use the toISOString() method and then remove the timezone information from the resulting string.

const timestamp = 1701699255;
const date = new Date(timestamp * 1000);
const dateString = date.toISOString().replace(/T/, ' ').replace(/\..+/, '');
console.log(dateString); // "YYYY-MM-DD HH:mm:ss" without timezone information.

Another approach is to use getUTC* methods in case you want to keep the Date object and display it without timezone.

const timestamp = 1701699255;
const date = new Date(timestamp * 1000);

const year = date.getUTCFullYear();
const month = (date.getUTCMonth() + 1).toString().padStart(2, '0');
const day = date.getUTCDate().toString().padStart(2, '0');
const hours = date.getUTCHours().toString().padStart(2, '0');
const minutes = date.getUTCMinutes().toString().padStart(2, '0');
const seconds = date.getUTCSeconds().toString().padStart(2, '0');

const dateString = `${year}-${month}-${day} ${hours}:${minutes}:${seconds}`;
console.log(dateString);

You can set a time zone for the duration of the query thusly:

TZ=America/New_York date

Note the whitespace between the TZ setting and the date command. In Bourne-like and rc-like shells, that sets the TZ variable for the current command only. In other shells (csh, tcsh, fish), you can always use the env command instead:

env TZ=America/New_York date

tl;dr

On Linux systems. time zones are defined in files in the /usr/share/zoneinfo directory. This structure is often referred to as the "Olson database" to honor its founding contributor.

The rules for each time zone are defined as text file lines which are then compiled into a binary file. The lines so compiled, define the zone name; a range of data and time during which the zone applies; an offset from UTC for the standard time; and the notation for defining how transition to-and-from daylight saving time occurs, if applicable.

For example, the directory "America" contains the requisite information for New York in the file America/New_York as used, above.

Beware that the specification of a non-existent zone (file name) is silently ignored and UTC times are reported. For example, this reports an incorrect time:

TZ="America/New York" date ### WRONG ###

The Single UNIX Specification, version-3, known as SUSv3 or POSIX-2001, notes that for portability, the character string that identifies the time zone description should begin with a colon character. Thus, we can also write:

TZ=":America/New_York" date
TZ=":America/Los_Angeles" date

As an alternative method to the specification of time zones using a path to a description file, SUSv3 describes the POSIX model. In this format, a string is defined as:

std offset [dst[offset][,start-date[/time],end-date[/time]]]

where std is the standard component name and dst is the daylight saving one. Each name consists of three or more characters. The offset is positive for time zones west of the prime meridian and negative for those east of the meridian. The offset is added to the local time to obtain UTC (formerly known as GMT). The start and end time fields indicate when the standard/daylight transitions occur.

For example, in the Eastern United States, standard time is 5 hours earlier than UTC, and we can specify EST5EDT in lieu of America/New_York. These alternatives are not always recognized, however, especially for zones outside of the United States and are best avoided.

HP-UX (an SUSv3 compliant UNIX) uses textual rules in /usr/lib/tztab and the POSIX names like EST5EDT, CST6CDT, MST7MDT, PST8PDT. The file includes all of the historical rules for each time zone, akin to the Olson database.

NOTE: You should be able to find all of the time zones by inspecting the following directory: /usr/share/zoneinfo.