how to get the GMT time zone return format as timestamp

Hi Sathish David  Kumar N,

Can you try this ?

Instant instant = Instant.now();
Timestamp timestamp = Timestamp.from(instant);
assertEquals(instant.toEpochMilli(), timestamp.getTime());

Select allOpen in new window

Try

import java.time.Instant;
import java.time.ZoneId;
import java.time.ZonedDateTime;
import java.time.format.DateTimeFormatter;

public class MachineTimestamp {
    static final String DATEFORMAT = "dd-MM-yyyy HH:mm:ss";

    public static void main(String args[]) {
        Instant machineTimestamp = Instant.now();
        System.out.println("The current machine timestamp in UTC:" + machineTimestamp);
        ZonedDateTime gmtDT = machineTimestamp.atZone(ZoneId.of("UTC"));
        System.out.println("Current ts in GMT: " + gmtDT.format(DateTimeFormatter.ofPattern(DATEFORMAT)));
    }
}

Select allOpen in new window

I got wrong answer @CEHJ

The current machine timestamp in UTC:2019-10-31T06:56:24.218Z
Current ts in GMT: 2019-56-31 06:56:24

I want java.sql.timestamp

:)