SQL

sql timestamp to date

date_format(from_unix_time(`my_date`), '%e %b %Y') AS 'date_formatted'
cast(my_date as DATE)

String to sql Timestamp

import java.sql.Timestamp;

public class StringToTimeStamp {
    public static void main(String[] args) {

        String dateTime = "2020-12-12 01:24:23";

        Timestamp timestamp = Timestamp.valueOf(dateTime);
        System.out.println(timestamp);
    }
}

timestamp to date sql server

#--------------------------------SQL SERVER----------------------------------
#use this to convert forom bigint unix to datetime
#replace 1500123123 with your number
select  DATEADD(second,1500123123, CAST('1970-01-01 00:00:00' AS datetime))

#it's way better to put this in a function and call the function