You can simply use the modulo operator: int lastTwoDigits = Calendar.getInstance().get(Calendar.YEAR) % 100; Edit: Using a SimpleDateFormat, as @R.J proposed, is the better solution if you want the result to be a string. If you need an integer, use modulo.
TO_TIMESTAMP(‘20151206 00:00:00’, ‘yyyymmdd hh:mm:ss’) It is wrong in two ways: 1. Incorrect format code You have repeated the MM format mask twice. MM is month and MI is minutes. SQL> SELECT TO_TIMESTAMP(‘20151206 00:00:00’, ‘yyyymmdd hh:mm:ss’) FROM dual; SELECT TO_TIMESTAMP(‘20151206 00:00:00’, ‘yyyymmdd hh:mm:ss’) FROM dual * ERROR at line 1: ORA-01810: format code appears twice 2. … Read more
I also recommend using Joda as mentioned before. Solving your problem using standard Java Date objects only can be done as follows: // **** YOUR CODE **** BEGIN **** long ts = System.currentTimeMillis(); Date localTime = new Date(ts); String format = “yyyy/MM/dd HH:mm:ss”; SimpleDateFormat sdf = new SimpleDateFormat(format); // Convert Local Time to UTC (Works … Read more
You need to convert the timestamp to datetime first: SELECT strftime(‘%d – %m – %Y ‘, datetime(1281353727, ‘unixepoch’)) FROM Visits;
Use this. java.util.Date date = new Date(“Sat Dec 01 00:00:00 GMT 2012”); SimpleDateFormat formatter = new SimpleDateFormat(“yyyy-MM-dd”); String format = formatter.format(date); System.out.println(format); you will get the output as 2012-12-01
Here’s a fun hacky way to do exactly what you are looking for =) date -u -d @${i} +”%T” Explanation: The date utility allows you to specify a time, from string, in seconds since 1970-01-01 00:00:00 UTC, and output it in whatever format you specify. The -u option is to display UTC time, so it … Read more
You can convert unixTimestamp to date using Date(timeIntervalSince1970:). let unixTimestamp = 1480134638.0 let date = Date(timeIntervalSince1970: unixTimestamp) If you want to display date in string with specific formate than you can use DateFormatter like this way. let date = Date(timeIntervalSince1970: unixtimeInterval) let dateFormatter = DateFormatter() dateFormatter.timeZone = TimeZone(abbreviation: “GMT”) //Set timezone that you want dateFormatter.locale … Read more