Re: [R] Some SQL Challenges

Don't understand what this has to do with SQL, or why you're asking for SQL solutions in an R mailing list, but here are some R suggestions. (abbreviating "COLUMN" with "C") At 11:40 AM -0700 8/3/09, JoK LoQ wrote: Hi, Im trying to complete a list of jobs using SQL Querries and some "if else

Re: [R] Some SQL Challenges

To insert values with SQL: INSERT INTO table_name VALUES (value1, value2, value3,...). To deal with those date problems Im almost sure that R has a Date Function somewhere in its manual. You should take a look. Just the best help I can give, sorry good look JoK LoQ wrote: > > Hi, > > Im t

[R] Some SQL Challenges

Hi, Im trying to complete a list of jobs using SQL Querries and some "if else" commands but im stucked in some steps. Could any of you give me some help? -in COLUMN1 change the format 20JAN2000:00:00:00 to 20JAN2000 and exclude every row that date is different from 20. -extract the first charac