similar to: find method use without sql in mind

Hey there all, Is there some way to tell rails or sql server to ignore the time in a datetime field when doing a comparison? For example, if I do something like select * from users where registration_date = ?, @date where @date might equal some user input like ''03/14/2006'' The result is nothing returned, because in my tables the datetime field looks like this: 3/14/2006

The US water year extends from 01 October yyyy-1 through 30 September yyyy and is referenced by the year starting on the included 01 January yyyy. I'd like to be able to find the annual means for the water year. To do so I've taken the input date-time, which is in the usual format "1991-10-07 10:35:00" changed it by: w$d<-as.POSIXct(w$date.time) Now I can add an

dear kind helper, i would like to know how to find the annual maximun for a table that basicly looks like this: date time measurement1 measurement2 measurement3 mm/dd/yyyy hh:mm:ss m1 m2 m3 there are about 9000 measurements for each year, which makes it quite large... i already tried to subset all rows for a year, to find the maximum within these choosen rows, y <-

This is the very last thing I need to make everything work properly. My query: sqlQuery(conn, "select to_char(lsd,'yyyy-mm') as yr,ttl_mo_prcp from mo_rains where stn_num=023000") Is there a way to may the stn_num in the query variable, ie make it so that whenever my script is run, the user must choose and input the station number? Cheers. -- View this message in context:

Here''s my problem. I have an ''Item'' model with a date column called "inserted_on" formatted as "yyyy-mm-dd hh:mm:ss:t". I want to find all records that were inserted more than 30 days ago. How would I say that using the Item.find ( :all .....) method? I don''t fully understand the syntax. I tried @result = Item.find( :all, :conditions =>

I am trying, without success, to compile a custom locale for the utf-8 character set. I have issued this command: localedef --no-archive -f UTF-8 -i /usr/share/i18n/locales/en_CA at yyyy-mmm-dd en_CA at yyyy-mmm-dd.utf8 which produces the requisite files without reporting an error but which none-the-less insists on using the iso-8859-1 charset: LC_ALL=en_CA at yyyy-mm-dd locale charmap

https://bugzilla.mindrot.org/show_bug.cgi?id=3781 Bug ID: 3781 Summary: IPv6 inconsistency causes TOFU Product: Portable OpenSSH Version: 9.7p1 Hardware: All OS: Other Status: NEW Severity: normal Priority: P5 Component: ssh Assignee: unassigned-bugs at mindrot.org

Hi, Anyone know where the "record" method is defined. Its used in generators like in the scaffold generator. An extract from it is below (taken from scaffold_generator.rb): def manifest record do |m| # Check for class naming collisions. m.class_collisions controller_class_path, "#{controller_class_name}Controller",

Hello List, with CentOS 7.2 it is not longer possible to run fail2ban on a Server ? I install a new CentOS 7.2 and the EPEL directory yum install fail2ban I don't change anything only I create a jail.local to enable the Filters [sshd] enabled = true .... ..... When I start afterward fail2ban systemctl status fail2ban is clean But systemctl status firewalld is broken ? firewalld.service -

Dear list, I am trying to evaluate how many elements in a vector equal a certain value. The vectors are the columns of a data.frame, read in using read.table(): > dim(data) [1] 2600 742 > data[1:5,1:5] SNP001 SNP002 SNP003 SNP004 SNP005 1 GG AA TT TT GG 2 GG AA TC TT GG 3 GG AC CC TT GG 4 AG AA TT TT GG 5

Hi all! I''m hoping someone here might be able to help. I''m familiar with several UNIX''es, though farily new to Linux... I''m running RHEL 5.2. I''ve got the RHEL kernel headers installed, etc, and compiled xen-3.3. Once that was built, I rebuilt libvirt, etc, the kernel, and all the modules. The whole mess boots and runs fine... mostly. My hardware

Hello All, I am having a problem with samba's ability to interpret certain files with windows 2k clients. Setup Details: Linux ( RedHat 7.3 ) File Server Win 2k Clients Samba v2.2.3a Kernel 2.4.18 statically compiled. Problem Description: When copying jpegs from a Win2k client which is displaying the JPEGS in thumbnail mode, to the Linux / Samba file server, 3 files are copied as

Hi folks, I have been tormented for some time by Excel's habit of exporting dates to CSV files as mm/dd/yyyy format even if the dates are formatted dd/mm/yyyy in the display. What's worse, if there are dates that are of ambiguous (6/6/2011) and unambiguous (16/6/2011) format in the same column, Excel reformats the unambiguous dates and leaves the ambiguous ones as they were! Yesterday

Hello, I am trying to setup a samba4 AD dc in my network using smb-tool. Everything seems to work except DNS forwarding. If I query for the dc root at dc:~# nslookup dc.local.domain.it I get the correct answer: root at dc:~# nslookup dc Server:???????? aaa.bbb.ccc.ddd Address:??????? aaa.bbb.ccc.ddd#53 Name:?? dc.xxxx.yyyy.it Address: aaa.bbb.ccc.ddd but if I query for an external domain: root

Hi, Presently I have the latest full backup in a 'current' directory and 30 day incrementals in 'YYYY-MM-DD' format directories. Without changing that directory structure I'd like the 'YYYY-DD-MM' directories to contain the full system hardlinked (when applicable) to 'current'. What rsync command-line options could provide me with this? Thanks,

I am reading dates in Excel2007 into R. Here are the functions I used: library(RODBC) channel<-odbcConnectExcel2007("myfile.xlsx") tmp<-sqlFetch(channel,"1",as.is=T) The dates in myfile.xlsx are all in this format: mm/dd/yyyy. But when I read it to R, some columns look like "yyyy-mm-dd 00:00:00", some columns look like "yyyy-mm-dd", and some

Hi all, I am using InstantRails with MySQL-Front. Date is stored in format yyyy-mm-dd in database. I want to retrieve and show date in dd-mm-yyyy in my view.rhtml. How can I change it to dd-mm-yyyy form. Please help me out. Thanks -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google

Dear all, i have a problem with sssd in conjunction with ldap on a centos 7 x86_64 box. ldap works fine. I can login there as an usual user registred in ldap. I want now restrict the access with ldap's host attribute. This is beeing ignored. Still every ldap user can login, no matter what the host attribute says. I googled around and only found that sssd.conf need two lines: access_provider

> library(foreign) > da<-read.dta(file.choose()) > da startdat starttim enddate endtime days hoursmin secused 1 2005-01-11 2 2005-12-15 20.19 NA NA 9 > attributes(da) $datalabel [1] "Example of use of date and time functions" $time.stamp [1] "15 伿伄伓侢佋伮 2005 20" $names [1] "startdat" "starttim"

Dear R-WinEdit users, I got a simple question, but somehow I cannot find the answer, although I have tried a lot! I got an ASCII-file and I want to import it into R, so that every character is defined by [i;j]. The rows are not of the same length. the file looks like the following shortened abstract example: name: xxxxx xxxx age: 9.9.99 record number: 999 title: xxxxx xxxx xxx keywords: xxx xx