I have a column of the TIMESTAMP WITHOUT TIME ZONE type and would like to have that default to the current time in UTC. Getting the current time in UTC is easy: postgres=# select now() at time zone ‘utc’; timezone —————————- 2013-05-17 12:52:51.337466 (1 row) As is using the current timestamp for a column: postgres=# … Read more
I want to get time difference like “posted 2 days ago”. I know you can use the following to get the difference. human_time_diff( get_the_time(‘U’), current_time( ‘timestamp’ ) ) . ‘ ago’; But I don’t want to use that date_default_timezone_set(‘Australia/Melbourne’); // set the time zone $timestamp = strtotime( $post->post_date ); // get timestamp $now = time();// … Read more
I am looking for a way that I could add some code to my wordpress template to display the time of a post in relative terms. So if, for example, I posted something 5 minutes ago it would say something along the lines of Posted 6 minutes ago or 2 days ago, or 1 week … Read more
I have a data file containing timestamps like “1331856000000”. Unfortunately, I don’t have a lot of documentation for the format, so I’m not sure how the timestamp is formatted. I’ve tried Python’s standard datetime.fromordinal() and datetime.fromtimestamp() and a few others, but nothing matches. I’m pretty sure that particular number corresponds to the current date (e.g. … Read more
How to get timestamp in string format in Java? “yyyy.MM.dd.HH.mm.ss” String timeStamp = new SimpleDateFormat(“yyyy.MM.dd.HH.mm.ss”).format(new Timestamp()); This is what I have, but Timestamp() requires an parameters… 8 Answers 8
I want to store the current time using the update_option and then compare it if the set time was 3 days ago. I want to know in what format I should store the time? and then how can I compare it with current time and find the difference in the days? 1 Answer 1 You … Read more
For some reason, I’m having difficulty converting a date value stored in a meta field to a unix timestamp (and back again). If I save the date as a string it all works fine, but if I convert it to a timestamp using strtotime it won’t save the value. My working code looks like this: … Read more
What is the best way to get the current system time milliseconds? 18 Answers 18
I have dt = datetime(2013,9,1,11), and I would like to get a Unix timestamp of this datetime object. When I do (dt – datetime(1970,1,1)).total_seconds() I got the timestamp 1378033200. When converting it back using datetime.fromtimestamp I got datetime.datetime(2013, 9, 1, 6, 0). The hour doesn’t match. What did I miss here? 12 Answers 12
The following loop works great for me in getting posts with a given date with the use of the_time(…): <?php $myPost = new WP_Query( array( ‘posts_per_page’ => ’50’, ‘orderby’ => ‘modified’, ‘order’ => ‘DESC’ )); while ($myPost->have_posts()): $myPost->the_post(); ?> <div class=”timeline-group”> <p class=”modified-time”><?php the_time(‘F j, Y’) ?></p> <h5><a href=”https://wordpress.stackexchange.com/questions/274206/<?php the_permalink();?>”><?php the_title();?></a></h5> </div> <?php endwhile; //Reset … Read more
