I started using the jOra eclipse plugin. The plugin seems pretty robust and I'm hoping to stop using SQLDeveloper for 95% of my database needs. Many of our tables have columns of type TIMESTAMP with LOCAL TIME ZONE. I can connect to the oracle DB using a jdbc string and the plugin seems to function very well. However, when I try to...
Is php date() and time() function works between the years 1901-2038. What function will I use for my long based projects. or I am wrong? ...
I must be doing an obvious mistake but I can't figure it out. I am importing a date stored in a mysql database (it is stored by the ExpressionEngine CMS). It is a unix timestamp, i.e. seconds since 1/1/1970 00:00. So I'm doing something like this: DateTime dateTime = new System.DateTime(1970, 1, 1, 0, 0, 0, 0); dateTime = dateTime.Add...
I have a table with a column of type timestamp which defaults current_timestamp and updates to current_timestamp on every update. I want to remove the "on update" feature on this column. How do I write the alter statement? I tried the following: ALTER TABLE mytable alter column time set DEFAULT now(); but this didn't work. than...
I'm using a Java 64-bit long representation of UTC time System.currentTimeInMillis() and sending that to an Actionscript client as a String, and I want to convert to an Actionscript UTC Date. The trouble is Actionscript (and other ECMAScript like Javascript) only use a 64-bit Floating point number representation, so precision is lost w...
I'm displaying the date and time like this 24-Nov-2009 17:57:35 I'd like to convert it to a unix timestamp so I can manipulate it easily. I'd need to use regex to match each part of the string then work out the unix timestamp from that. I'm awful with regex but I came up with this. Please suggest improvements ^.^ /((\d){2}+)-((Ja...
Is there a way to back up a mercurial repository while preserving the files' timestamps? Right now, I'm using hg clone to copy the repository to a staging directory, and the backup program picks up the files from there. I'm not pointing the backup program directly at the repository because I don't want it to be changing (from commits) w...
How would I get a UNIX timestamp (number of seconds since 1970 GMT) from a Date object in a Rails app? I know Time#to_i returns a timestamp, but doing Date#to_time and then getting the timestamp results in something that's off by about a month (not sure why...). Any help is appreciated, thanks! Edit: OK, I think I figured it out- I w...
Hi All, I would like to know how to calculate difference between two different timezones / timestamps in Blackberry application. For e.g. Calculate difference in server timestamp and client timestamp Please help. Thanks. ...
Hi guys could you please help me with this. I know it is silly but can't find unswer anywhere: I have a query that shows events from the today time_stamp but I want to include today as well. How do I add this to this query? ... WHERE events.event_date > current_timestamp ORDER BY convert (event_date, date) ASC As it is formed it doe...
So I've got a users table; storing things like username, email, etc. I then have a user_settings table. Instead of standard columns like timestamp_logged_in, profile_views, etc., I have it organized as key/value combo. For example, the columns are: user_settings_ID user_ID name value A sample record would be: 82 2 'timestamp_logged_in'...
When writing Perl scripts I frequently find the need to obtain the current time represented as a string formatted as YYYY-mm-dd HH:MM:SS (say 2009-11-29 14:28:29). In doing this I find myself taking this quite cumbersome path: man perlfunc /localtime to search for localtime - repeat five times (/ + \n) to reach the relevant section of...
I am adding the current date and time to my database using the following code: $current_date_time = time(); echo date('n/j/y g:ia',$current_date_time); It shows up as 11/29/09 12:38am when it should be 11/29/09 11:38am The time is ahead by one hour. I am in the Pacific time zone and my hosting provider is in Utah, the Mountain Time...
Does anyone know of a good class / library to convert English representations of time into timestamps? The goal is to convert natural language phrases such as "ten years from now" and "three weeks" and "in 10 minutes" and working out a best match unix timestamp for them. I have hacked up some pretty poor and untested code to get going ...
For the purposes of binary / source code verification, i'd like to be able to make two compiles on the same computer 2 weeks apart and have the binaries be identical and thus pass some checksum test. So far I've found that most likely the timestamp will be written by the compiler into the binary. I can work around this by doing the com...
I am working on a system related to tv recordings. I am parsing the following xml from another system (to which i have no documentation): <Program FileName="2009.11.07-Saturday 07 November 2009.dvr-ms" SubChannel="ABC1" StartTime="633931722046825183" StopTime="633932388000119414" ActualStopTime="633932388016825183" ShareShow="True" /> ...
for n in `cd src; find . -name "*.java"; cd -`; do a=`echo $n | cut -d '.' -f2`; if [[ src/$a.java -nt build/$a.class ]]; then echo src/$a.java; fi; done It lists all the java files in the src tree; then for each one, it removes the suffix ".java" (cut -d '.' -f2 because find . output is prefixed with .). It then uses -nt to ...
I'm writing a socket program that maintains FIFO queues for two input sockets. When deciding which queue to service, the program pulls the most recent time-stamp from each queue. I need a reliable method for comparing two timeval structs. I tried using timercmp(), but my version of gcc doesn't support it, and documentation states that ...
Hi, I have a string like '2008-01-01 11:09:11' How do I convert this to a datetime ? ...
We use LINQ in our ASP .NET application to run database queries and commands. We have been having concurrency issues on updates to tables in which we update the value of a Date field. More specifically, if two users click a button at the exact same time and the code attempts to update a Date field in the database then the built-in optim...