I have a timezone aware timestamptz field in PostgreSQL. When I pull data from the table, I then want to subtract the time right now so I can get it’s age. The problem I’m having is that both datetime.datetime.now() and datetime.datetime.utcnow() seem to return timezone unaware timestamps, which results in me getting this error: TypeError: … Read more
On one server, when I run: mysql> select now(); +———————+ | now() | +———————+ | 2009-05-30 16:54:29 | +———————+ 1 row in set (0.00 sec) On another server: mysql> select now(); +———————+ | now() | +———————+ | 2009-05-30 20:01:43 | +———————+ 1 row in set (0.00 sec) 23 Answers 23
I am trying to subtract one date value from the value of datetime.datetime.today() to calculate how long ago something was. But it complains: TypeError: can’t subtract offset-naive and offset-aware datetimes The return value from datetime.datetime.today() doesn’t seem to be “timezone aware”, while my other date value is. How do I get a return value from … Read more
I am looking for a function to convert date in one timezone to another. It need two parameters, date (in format “2012/04/10 10:10:30 +0000”) timezone string (“Asia/Jakarta”) The timezone string is described in http://en.wikipedia.org/wiki/Zone.tab Is there an easy way to do this? 29 Answers 29
Some background: I have a Java 1.6 webapp running on Tomcat 7. The database is MySQL 5.5. Previously, I was using Mysql JDBC driver 5.1.23 to connect to the DB. Everything worked. I recently upgraded to Mysql JDBC driver 5.1.33. After the upgrade, Tomcat would throw this error when starting the app. WARNING: Unexpected exception … Read more
From the server I get a datetime variable in this format: 6/29/2011 4:52:48 PM and it is in UTC time. I want to convert it to the current user’s browser time zone using JavaScript. How this can be done using JavaScript or jQuery? 38 Answers 38
I have a web page with three dropdowns for day, month and year. If I use the JavaScript Date constructor that takes numbers, then I get a Date object for my current timezone: new Date(xiYear, xiMonth, xiDate) Give the correct date, but it thinks that date is GMT+01:00 due to daylight savings time. The problem … Read more
I have date time in a particular timezone as a string and I want to convert this to the local time. But, I don’t know how to set the timezone in the Date object. For example, I have Feb 28 2013 7:00 PM ET, then I can var mydate = new Date(); mydate.setFullYear(2013); mydate.setMonth(02); mydate.setDate(28); … Read more
Want to improve this post? Provide detailed answers to this question, including citations and an explanation of why your answer is correct. s without enough detail may be edited or deleted. When I create a new Date object, it is initialized to the current time but in the local timezone. How can I get the … Read more
Does time.time() in the Python time module return the system’s time or the time in UTC? 9 s 9 The time.time() function returns the number of seconds since the epoch, as a float. Note that “the epoch” is defined as the start of January 1st, 1970 in UTC. So the epoch is defined in terms … Read more