This is my code: $testtime = str_replace('.', '-', '2009.07.08 17:01'); $timestamp = strtotime($testtime); echo $timestamp . "\n"; echo $testtime . "\n"; echo date('Y-m-d H:t', $timestamp); And this is my output: 1247065260 2009-07-08 17:01 2009-07-08 17:31 What's wrong? Thank you in advance. ...
I am looking for a way to retrieve or extract the timestamp of the recording from DV AVI files. The timestamp should be part of the AVI file's metadata. The files were originally imported from DV to PC and a DV format in an AVI wrapper. A library providing an API - or a command-line tool would be ok. I am going to be using this on Mac, ...
I have a Unix timestamp that comes from a database that is (unfortunately) in a timezone with a certain of either +3600 or +7200, depending on if it's DST or not. This has never been a problem before, but our website is currently moving to a more international audience and because of Javascript interaction with said timestamps, I need to...
We're running into a strange error using Oracle Odp.Net (connecting to Oracle 9). The problem is illustrated by the code snippet below. This is the error we're experiencing: ORA-00600: internal error code, arguments: [15419], [severe error during PL/SQL execution], [], [], [], [], [], [] ORA-06544: PL/SQL: internal error, arguments: [...
how do i send device token from my native iphone app with a specific timer request so that after the specified time push notification alert comes to device. ...
I extracted year, month, day, hour, minute, second, and millisecond data from human readable text (it wasn't in a timestamp format, but rather something like "X started at HH:MM:SS.SSS on DD MMM YYYY and ended at HH:MM:SS.SSSS on DD MMM YYYY"), so for each recorded event, I have each of the values. However, I need to turn those into som...
I use PDO prepared statements in a Web application I'm building. I have a timestamp column set to current_timestamp as default value. Using a timestamp should normally assign the current timestamp when the column value is null, same as now() would do. But no matter what I try, I get a NULL value if I set the timestamp column to null and...
How does MySQL store timestamps internally? Is it an int, or a string or something else? ...
My problem is about the timestamp column in one of my database tables. This field is required because sqlserver automatically generates it. Since this column is required subsonic included it in the insert query.. im using subsonic 3.0 info.Save(); error message: Cannot insert an explicit value into a timestamp column. Use INSERT w...
I have a a date in strptime that I want to show as 'X hours ago'. I can happily convert hours into days and weeks etc. but I don't know how to do the initial sum. Here is how I'm converting the string into strptime: time.strptime(obj.created_at, '%a %b %d %H:%M:%S +0000 %Y') p.s. bonus points for figuring out why it won't take %z for ...
A have two entities. For example timing settings and orders. @Entity public class TimingSettings{ @Basic private Long orderTimeout = 18000; //for example 18000 sec .... } @Entity public class Order{ @Basic @OneToOne private TimingSettings timingSettings; @Temporal(value = TemporalType.TIMESTAMP) @Co...
I don't get it I want to calculate something I want to check if the time out of the database is before or after this time so I made this. $qVraagCodeOp = "SELECT * FROM `code` WHERE `Code_Code` = '$value'"; $rVraagCodeOp = mysql_query($qVraagCodeOp); $aVraagCodeOp = mysql_fetch_assoc($rVraagCodeOp); $oldTime = mktime($aVraag...
I wrote a desktop application and was using datetime.datetime.utcnow() for timestamping, however I've recently noticed that some people using the application get wildly different results than I do when we run the program at the same time. Is there any way to get the UTC time locally without using urllib to fetch it from a website? ...
What is the easiest or most elegant way to convert a RFC 1123 date (From an HTTP-Expiration-header) to a UNIX timestamp? Example: Sun, 14 Aug 2005 16:13:03 GMT Do I really have to 'substr' everything? ...
I was just about to write this myself, but I know this has to exist and I'm just managing to avoid all the Google keywords that would lead me right to it. I would be looking for something like DDDMMMYYY where D, M, Y are the number of days, months, and years. So 00103000 would indicate a span of three months and one day, or 000000001 wo...
Hi, I'm currently getting the error: "java.sql.SQLException: ORA-01843: not a valid month" which I assume is to do with the way I am setting a timestamp... So I have a query like this : select * from A_TABLE where A_TIMESTAMP_COL < '1252944840000' But it doesn't work...and I don't want to have to convert it to a date ideally. Is the...
I have to work with dates and times in my .NET project, and one of the things I need to do is get the current date and add 2 weeks onto it, and if the date the user entered is after those two weeks throw out an error. Or, if the date they entered is before the current date throw out another error. Now, I know how to do this, but not wit...
I have a table containing view/click records. The time is stored in a unix timestamp and I need to be able to pull out all of them within the specific month/day (based off of timestamps), but more importantly and the part I don't know how to do is group them by hour. I need to be able to do this in a single query rather than looping thr...
Hi all, I got UTC timestamps and want to display them for different timezones. Maybe an example can clarify what I am trying to do: Given the timestamp 1259431620000 those times should be displayed: Atlanta 13:07 San Francisco 10:07 London 17:07 Sydney 04:07 The cities m...
I'm using the America/New York timezone. In the Fall we "fall back" an hour -- effectively "gaining" one hour at 2am. At the transition point the following happens: it's 01:59:00 -04:00 then 1 minute later it becomes: 01:00:00 -05:00 So if you simply say "1:30am" it's ambiguous as to whether or not you're referring to the first tim...