I need to convert a unix timestamp to a date object. I tried this: java.util.Date time = new java.util.Date(timeStamp); Timestamp value is: 1280512800 The Date should be “2010/07/30 – 22:30:00” (as I get it by PHP) but instead I get Thu Jan 15 23:11:56 IRST 1970. How should it be done? 10 Answers 10
Are timestamp values stored differently in PostgreSQL when the data type is WITH TIME ZONE versus WITHOUT TIME ZONE? Can the differences be illustrated with simple test cases? 6 Answers 6
Want to improve this post? Provide detailed answers to this question, including citations and an explanation of why your answer is correct. Answers without enough detail may be edited or deleted. I am trying to convert a timestamp of the format 2009-09-12 20:57:19 and turn it into something like 3 minutes ago with PHP. I … Read more
I want to get the current timestamp like that : 1320917972 int time = (int) (System.currentTimeMillis()); Timestamp tsTemp = new Timestamp(time); String ts = tsTemp.toString(); 14 Answers 14
I am using a sitemaps plugin which in very complex ways sets the timezone of <lastmod> (i.e. last modified time) for posts to GMT. Temporarily, until the plugin developer fixes it, I need to enforce a custom timezone on the plugin. The simple and straightforward way that I’ve found is to add something like date_default_timezone_set( … Read more
For a certain Hibernate entity we have a requirement to store its creation time and the last time it was updated. How would you design this? What data types would you use in the database (assuming MySQL, possibly in a different timezone that the JVM)? Will the data types be timezone-aware? What data types would … Read more
I would like to know if anyone knows a way of adding a timeframe (say 20 years) to the datestamp on a set of posts, and then running a query on the loop which uses the new date? Basically what I want to do is have a series of normal news posts. In addition to … Read more
I want to extract just the date part from a timestamp in PostgreSQL. I need it to be a postgresql DATE type so I can insert it into another table that expects a DATE value. For example, if I have 2011/05/26 09:00:00, I want 2011/05/26 I tried casting, but I only get 2011: timestamp:date cast(timestamp … Read more
I am a bit confused about using dates/times along with timezones in WordPress. I have the following questions: What is the purpose of the timezone setting in the Admin -> Settings section? Assume current time in GMT is 20:00, and Assume I am in EST (so it is 16:00 in EST time), how is the … Read more
I have trouble converting Unix timestamp (i.e. 1473897600) to WordPress friendly date which displays at the date input field. I have a frontpage, post edit panel which is showing Unix timestamp. I guess this is the code for getting the post’s date; <?php $post_to_edit = array(); $post_to_edit = get_post($_POST[‘postid’]); $date = $_POST[ ‘_single_date’ ]; ?> … Read more
