Does anyone know of any SCM(s) (e.g. svn, git, etc) that would allow me to quickly access data as it was at a given actual time without deliberately tagging it or parsing big logs to work out what version was active at the time? i.e. Store values for file=X of A (at 9am),B (at 10am),C (at 11am),D (at 2pm). I want to be able to quickly ...
Hello, Is there any PHP function that returns time format as the MySQL fuction NOW() I know how to do it using date() .. but I am asking if there is a function only for this. e.g. "2009-12-01 00:00:00" ...
Hi, I'm using a open-source library for i2c bus actions. This library frequently uses a function to obtain an actual time-stamp with millisecond resolution. Example Call: nowtime = timer_nowtime(); while ((i2c_CheckBit(dev) == true) && ((timer_nowtime() - nowtime) < I2C_TIMEOUT)); The application using this i2c library uses a lot o...
I read a mysql timestamp can only hold a value from 19700101000000 to sometime in the year 2037. I seriously doubt my app will be around then, well i'm sure it wont but any idea what will people use then for a timestamp, a text field? Below is an example of how I currently insert a mysql record with a datetime mysql field and you can ...
Need to be able to use dates beyond the 32-bit timestamp limit so upgraded our server to Windows Server 2003 64-bit version. And running php 5.2.5 64-bit. However still can't use dates beyond the 32-bit limit. echo strtotime("11-11-2050"); returns nothing. Running php on IIS 6.0 using C:\WINDOWS\system32\inetsrv\fcgiext.dll Let me ...
Hello, I am new to oracle, I have to create a function that returns current date and time. I am using this to return date; SELECT CURRENT_DATE FROM dual; Thanx ...
In our HR system, we want to calculate the number of years the employee has served the company. What we have is the joining date in TIMESTAMP column. What I am doing is: $timeNow = time(); // current time $joinDate = strtotime($users->fields['date_of_joining']); // from database $servicePeriod = $timeNow - $joinDate; // in seconds $se...
I would like to sign records in a database with a secure timestamp to prove they have not been altered by anyone after that date. What methods or services should I consider? RFC 3161? Does anyone provide that service /and/ have a reputable looking website? Is it possible to roll your own? ...
I have been fighting the timezone battle for weeks now, everyone thinks they know the solution and then they get a million upvotes but the reality is I am totaly 100% stuck, no answer ever given for timezone support in PHP/MySQL has worked 100% for me, so I am asking the question again on here in as much detail as I possibly can with cod...
Hi, I have created a table in oracle XE, and I have a field with type date. I would like if possible when I insert a row, that it automatically fills that field with the current date from the system. I am inserting the rows from the SQL prompt. Thanks ...
Hi, I am then using Fluent NHibernate and its automapping feature to map the the following simplified POCO class: public class Foo { public virtual int Id { get; set; } public virtual datetime CreatedDateTime { get; set; } } The CreatedDateTime field will map to a SQL DateTime by default. However if I do a test to check ...
I'm porting some PHP to C++. Some of our database code stores time values as unix time stamps *100 The php contains code that looks a bit like this. //PHP static function getTickTime() { return round(microtime(true)*100); } I need something like this: //C++ uint64_t getTickTime() { ptime Jan1st1970(date(1970, 1, 1)); ptime ...
I am working on a project that involves converting data into dos date and time. using a hex editor (Hex Workshop) i have looked through the file manually and and found the values I am looking for, however I am unsure how they are calculated. I am told that the int16 value 15430 corresponds to the date 06/02/2010 but i can see no correlat...
In PHP 5.2, how to get the last second in a day? time() + 86400 gets the next Day only? ...
For the purpose of organizing streamlined database timer-based polling, with every updating of database table I need to update a timestamp field in a SQL Server 2008 database (then poll, read its value, compare with the value in front-end and making decisions about reading the whole table). Regarding all this, how I could read system ti...
i currently use the context.timestamp function to get the time in the beginning of the request but i want to know if i can check the time sooner in the pipeline (before the load page phase) or the timestamp is the earlier time i can get. now i need to find the latest time after the request was processed, of course i can check the time in...
Is there some way how to commit into the SVN repository with old time / date or how to edit the time / date post commit? I have some archived sources which are very old, way before I have started using SVN, and I would now like to put them into the SVN and if possible to preserve their original date, so that SVN history matches the real...
Below is a really nice time ago plugin for jQuery, very similar to what they use here on SO. The problem for me is that it uses this to convert time. <time class="timeago" datetime="2008-07-17T09:24:17Z">July 17, 2008</time> That would be great except that I store time on my site in UTC timestamp and not as a formatted time, is the...
Possible Duplicate: Convert a string to a date in C++ I have a date/time string in a standardized format (RFC 1123) that I would like to convert to a unix timestamp to compare it with another date/time. I can convert a timestamp to a string by using strftime with the magic format string "%a,%d %b %Y %H:%M:%S GMT" The pro...
My understanding is that, in keeping with Interbase v6, Firebird 2.5 does not support the SQL-92 INTERVAL keyword. At least, so suggests this reference and my repeated SQLCODE -104 errors trying to get INTERVALs to work under Firebird's isql(1). How, then, do I account for the irregularities in our civil reckoning of time -- months are...