search for: sysdate

Hi, In my application I want to have the sysdate + 5 minutes. I know that the sysdate is in the variable ${DATTIME} But now I want to now how I get the sysdate + 5 minutes into a variable? Doe's anybody knows the answer? Kind Regards Arjan Kroon -------------- next part -------------- An HTML attachment was scrubbed... URL:...

Hi, I tried to remove the text starts by "--" to the end of the line as below sql=c("-- This is a comment line", "select sysdate -- This is a comment Text" , " from dual ") >sql [1] "-- This is a comment line" [2] "select sysdate -- This is a comment Text" [3] " from dual " I try to have this > sql [1] "select sysdate " [2] " from dual " Tha...

I have compiled and linked a 64 bit version of R (R 2.9.2) and the corresponding unix ODBC 64 bit package When issuing a SqlQuery, I get the following error > library(RODBC) > channel <- odbcConnect("OraLSH", <user>, <password>) > sqlQuery(channel,"select sysdate from dual") Error in .Call(C_RODBCFetchRows, attr(channel, "handle_ptr"), max, buffsize, : negative length vectors are not allowed > close(channel) > q() I know I can replace the call to sqlQuery with calls to its component functions odbcQuery and sqlGetResults to get the s...

I have compiled and linked a 64 bit version of R (R 2.9.2) and the corresponding unix ODBC 64 bit package When issuing a SqlQuery, I get the following error > library(RODBC) > channel <- odbcConnect("OraLSH", <user>, <password>) > sqlQuery(channel,"select sysdate from dual") Error in .Call(C_RODBCFetchRows, attr(channel, "handle_ptr"), max, buffsize, : negative length vectors are not allowed > close(channel) > q() I know I can replace the call to sqlQuery with calls to its component functions odbcQuery and sqlGetResults to get the s...

...le. Since I am now running it under WINE (yeah! it *almost* works great), I wonder if it is possible to hack wine so it tells the executed program some different date and time (changing systime in Linux tends to wreak havoc with makefiles and stuff) Can someone point out where the unix-to-windoze sysdate translation is done so I can hack it? TIA -- -- SNIP -- "The difference between genius and stupidity is that genius has limits" +--------------------------------------+ | Eduardo G. Andrade | | Ibiz Tecnologia | | eduardo@ibiz.com.br...

...ed! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL> select sysdate from dual; +--------------------+ | SYSDATE | +--------------------+ | 2010-02-26 13:57:00| +--------------------+ SQLRowCount returns -1 1 rows fetched SQL> quit; However, when I started up R console on the machine and test the RODBC connectivity to oracle, I got following error: [...

...on of R (R 2.9.2) and the corresponding unix ODBC 64 bit package The red highlighted text below is the error I'm getting trying to when invoking a sqlQuery > library(RODBC) > channel <- odbcConnect("OraLSH", <user>, <password>) > sqlQuery(channel,"select sysdate from dual") Error in .Call(C_RODBCFetchRows, attr(channel, "handle_ptr"), max, buffsize, : negative length vectors are not allowed > close(channel) > q() Any suggestions are greatly appreciated. Alexander Chelminsky Principal CSC GBS | p: +1 781 290 1620 | f: +1 781 890 1...

I''m working with a legacy Oracle db which has trunc(SYSDATE) and TO_DATE(''...'',''...'') as default values for some date columns. The oracle driver craps out with these default values or sets them to the default Jan 1, 2000 date. The culprit appears to be the cast_to_time method in oracle_adapter.rb. Any pointers on how to...

...st=localhost", "username", "password", {'RaiseError' => 1}); $query = "INSERT INTO auto (Callerid, Date, Time, Empid, Strid, Status) VALUES ('$callerid', sysdate(), sysdate(), '$empid', '$strid', '$stat')"; $sth = $dbh->prepare($query); $sth->execute(); $sth->finish(); $dbh->disconnect; $AGI->stream_file(beep); ####### Sub Routines ############ sub employeeid { my $empid = $AGI->get_data('...

Hello, Attached is a mail regarding question how to insert Date field using ROracle package. I am stuck with this problem and appreciate receiving help from gurus on this list. Code used mainly is: library(ROracle) ### --- Version 0.53 drv <- dbDriver("Oracle") con <- dbConnect( drv, "user/passwd") d <- data.frame(CDATE = "2004-03-10 10:12:00") ps

...> >>>> > > >>>> library(RODBC) > > >>>> connection <- odbcConnect("****", uid="****", pwd="****") > > >>>> d = sqlQuery(connection, "select userid, x, y, z from largetable where timestamp > sysdate -7") > > >>>> > > >>>> ...allowing me to pull data from the database table into the R object "d" and then use the R merge function. The problem however is that if "d" is too large it may fail due to memory limitations or be inefficient....

I have a potential client who is interested in employing my services to Web 2.0 their Web 1.0 perl+oracle app. I''ve only used rails with MySql so far. Are their any gotchas I should be aware of? Guy

...me default''s are not working in a way that would make sense. For instance a datetime column with a default of getdate() results in a default that looks like: :default => Sat Jan 01 00:00:00 Eastern Standard Time 2000. Are there any defaults for built in RDBMS functions such as getdate/sysdate. If not how is that handled? 4) db_schema_dump seems to blow up when ActiveRecord:: Base.connection.instance_variable_get("@connection")["AutoCommit"] = false is not set in environment.rb, however, all other commands don''t work unless AutoCommit is set to true. rake...

I have a table with "expires_on" a DATE field. "Show" and "Destroy" work, but "Edit" errors: /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_view/helpers/date_helper.rb:150:in `select_hour'' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_view/helpers/date_helper.rb:149:in `select_hour'' It only happens when

Hello all. I am a novice Ruby on Rails programmer, starting my first project using a legacy Oracle 10 database. Using ''reverse_scaffold'' I have created the models/controllers/views for my existing Oracle tables. All seems to work well, using /model/index, /model/show for most of my tables, *except* when one of the tables contains a Oracle ''date'' column, for

Hi all, I just started messing with wine (0.9.54 on Ubuntu 7.04-Feisty) a few weeks ago and there's some educational software I want to be able to run. It was made with VB, and I've managed to get it working fairly well except for an ActiveX control for showing Flash movies (.swf). I think it's unable to load the swf file because the box where the movie should show is blank, and