I'm writing an Ruby on Rails app using a legacy database. The problem I'm having is I have a unix timestamp column in the database. I'm trying to make it so that I can write a string like "2010-10-10" and get a Date when I read it. def birthdate bdate = self[:birthdate] if bdate == 0 '' else if bdate =~ $CetConfig.regexp...
Hi I try to select all records of a table (Postgres DB) with the following sql: SELECT * FORM 'tablename' WHERE 'myTimestampRow' >= now() There's allways an error message, telling me that there's an 'invalid input syntax for type timestamp with time zone: "myTimestampRow"'. What's wrong with the above query? ...
I have a Stored Procedure, Which has some select Statements and insert statements. Is there any way , I can log the Timestamps of execution before and after the sqls inside the Stored procedure? ...
Ok I seem to have got the most of the problem solved, I just need an expert eye to pick my error as I am stuck. I have a file of length [125 X 27] and I want to convert it to a file of length [144 x 27]. Now, I want to replace the missing files (time stamps) rows of zeros. (ideally its a 10 min daily average thus should have file leng...
Either I'm being stupid or something's wrong here. I have two SQL Servers, the one is on my local machine (local time +2 GMT) and the other is somewhere else (NOW() seems to return +8 GMT)and I access it through phpMyAdmin. I have a table that has a DATETIME column. I'm -trying- to store the current GMT/UTC time and then display it agai...
I have a couple textboxes that allows a person to enter a time and date. The time is entered with a textbox for hours, a textbox for minutes, a drop down for am/pm and some drop downs for months/hours/years So, I'd like to combine all of these to create a timestamp out of it and save it to the database. But i've confused myself in ho...
Hi all, I've been Googling Java timestamps, timers, and anything to do with time and Java. I just can't seem to get anything to work for me. I need a timestamp to control a while loop like the pseudo-code below while(true) { while(mytimer.millsecounds < amountOftimeIwantLoopToRunFor) { dostuff(); } mytimer.r...
I have a mySQL database with a timestamp field. It currently only has one entry while I'm testing, it is 2010-02-20 13:14:09 I am pulling from the database and using echo date("m-d-Y",$r['newsDate']) My end result is showing as 12-31-69 Anyone know why? Edit: editedit: disregard that edit... the FTP addon for notepad++ timed ou...
I want to get the date for current date in php. what i tried is here... echo $x."<br>"; echo date("D",$x)."<br>"; But the output was 21-02-10 Thu It is giving correct date but not the correct day value.Why..? What I want day is the date for monday for the current week which can be generated on any day of the week. so what I did w...
Is there a good+easy way to convert an Oracle Timestamp to an NSDate object on the iPhone? I have asked my customer to give me a DB with timestamps as Unix Timestamp (doubles with 0 = start of 1970) but it seems to be a problem for them. Thanks. Note: You can easily convert a Unix Timestamp to an NSDate with [NSDate dateWithTimeInter...
Hi all, I'm looking for a way to read SMPTE timecode embedded in DV video stream captured from Firewire camera. Can this be done using OpenCV? If not, could you point me to a good sample source code that does this using DirectShow? Thank you, Ben ...
I need help regarding generating dates and days of the last seven to ten days with respect to today. How an accurate timestamp can be created which can take care of week, month and year change ? ...
I have last_update_date column defined as DATE field I want to get time in milliseconds. Currently I have: TO_CHAR(last_update_date,'YYYY-DD-MM hh:mi:ss am') But I want to get milliseconds as well. I googled a bit and think DATE fields will not have milliseconds. only TIMESTAMP fields will. Is there any way to get milliseconds?...
Task: I need to check the current time with a respective time fixed by the admin, if the current time crosses the respective time, will update status 1) How can i convert the respective date to unix timestamp ? TIME STAMP: 1267285500 for DATE: 2 / 27 / 2010 @ 9:45:0 so that i can compare the unix timestamps of the current time and ...
I'm working with a WPF/C# app where I need to lock out users from accessing a particular feature for some amount of time. Basically, from the time a certain event happens, I want to prevent certain access for the next 24 hours. The simple case: Event happens, save timestamp (using DateTime or similar) User tries to access area 15 hou...
Hi! How can I get the current hour, minutes, and seconds from this? NSDate *now = [NSDate date]; Thanks! I want to have 3 int variables with the values stored in them, not a string which displays the values. ...
Hi, Assuming I have a unix timestamp in PHP. How can I round my php timestamp to the nearest minute? E.g. 16:45:00 as opposed to 16:45:34? Thanks for your help! :) ...
I need a shell command or script that converts a UNIX timestamp to a date. The input can come either from the first parameter or from stdin, allowing for the following usage patterns: ts2date 1267619929 and echo 1267619929 | ts2date Both commands should output "Wed Mar 3 13:38:49 2010". ...
I need to extract the 'full' hour of a timestamp. Like for 2010.03.04 13:13 I want 2010.03.04 13:00 (as a timestamp again). My current approach is: TO_TIMESTAMP(TO_CHAR(m.begin, 'yyyy.mm.dd hh24'), 'yyyy.mm.dd hh24') Is this really the way to go? Who good/bad does it perform (I plan to do a GROUP BY on it). Thanks for your input! ...
Hi, I'm trying to create a simple function which returns me a date with a certain number of subtracted days from now, so something like this but I dont know the date classes well: <? function get_offset_hours ($hours) { return date ("Y-m-d H:i:s", strtotime (date ("Y-m-d H:i:s") /*and now?*/)); } function get_offset_days ($days) { ...