apt-get install as root or su -c 'apt-get install' as user
apt-get install needs to be executed as root.
What is the difference regarding security of my computer of the both
On 2008-01-12, Tilo Baumann <email@example.com> wrote:
> apt-get install needs to be executed as root.
> What is the difference regarding security of my computer of the both
When you use su -c or sudo, root privileges are dropped as soon as the
command is complete. /var/log/auth.log shows what command was executed,
instead of just showing when someone logged in as root.
O...Getting most recent date and closes date
I'm trying to create a data set that has the most current(or recent)
date and the date closes to the that date for each ID.
Ultimately what I'm need is the number of days between the two dates.
The dataset would look like the following.
ID COUNT most_recent_date closes_date diff_days
2758 3 13APR2007 21MAR2007 23
2759 1 09FEB2007 09FEB2007 0
2760 2 26FEB...how to get tomorrow date using Date::CALC
want to take a date and return tomorrow's date..
How to convert $tomorrow back to YY-MM-DD format?
What is the inverse of Date_to_Days ?
... perl2.pl ---------------------------
use strict; use warnings; use Date::Calc qw(:all);
my ($yr2, $mon2, $day2, $tomorrow); my ($year, $month, $day);
$yr2 = 2005; $mon2 = 3; $day2 = 20;
print (" date- year: $yr2 month: $mon2 day:$day2 \n");
$tomorrow = Date_to_Days($yr2,$mon2,$day2) + 1;
print ("tomorrow: $tomorrow \n");
($year,$month,$day) = Today([$tomorrow]);
print ("tommorow- year: $year mon...Re: Getting most recent date and closes date
I don't know how this will scale to your 20M records. If then number
of IDs is "reasonable" it could be tolerable. Do you have an idea
about the number of IDs?
input id date:date9. @@;
format date date9.;
2758 21MAR2007 2758 10JAN2007 2758 13APR2007
2760 31JAN2007 2760 26FEB2007
2763 15JAN2007 2763 16APR2007 2763 29MAR2007 2763 01FEB2007
proc summary data=work.test nway;
rename=(_freq_=Count date_1=MostRecient date_2=Closest)
...Get BEST date? Get Closest Row?
Please excuse my last post. That was insane and i don't expect
anybody to think about that crazy excuse of a problem. But if someone
does have anything to offer for it that would be hugely appreciated
That said, and to boil down what I need.
I have two tables
Activity (many rows per ssn but no overlaping of dates))
Participation (many rows per snn but no overlaping of dates):
I need to write a function that returns the Earliest (BEST)
termination date given some values in.
ssn, effective date, peri...Have used apt-get install to install Wine again
but now when i try to run my program i get...
frazelle09@LaGrandota:~/.wine/drive_c/Ocean$ wine ./ocean.exe
Xlib: extension "GLX" missing on display ":0.0".
err:wgl:X11DRV_WineGL_InitOpenglInfo couldn't initialize OpenGL,
plus the Register dump and the Backtrace.
i haven't changed anything on the computer, just did apt-get update,
apt-get dist-upgrade and it asked if i wanted to install Wine. "Yes".
Bam. Now the program i use doesn't work anymore and if i run it from
the Terminal i get the above...
What's "GLX...How to get ORACLE Server Date, not local PC Date?
I'm trying to get the server date, but sysdate or any date function
returns the date of my PC ... is there any way to get this?
"alesk" <firstname.lastname@example.org> a �crit dans le message de news: email@example.com...
| I'm trying to get the server date, but sysdate or any date function
| returns the date of my PC ... is there any way to get this?
SYSDATE returns the current date and time set for the operating system on which the database resides.
Michel Ca...how do you get a list of all dates between two dates more than a day apart?
Say you have two dates, 2005-01-01 and 2005-01-24. I want to get a list or
array or all the date between and including those two dates.
I want to include this list in a query so I need it in a format like:
Any ideas? thanks
How about something like this....
$start = "2005-05-05";
$end = "2005-06-05";
$init_date = strtotime($start);
$dst_date = strtotime($end);
$offset = $dst_date-$init_date;
$dates = floor($offset/60/60/24) + 1;
for ($i = 0; $i < $dates; $i++)
$newdate = date("Y-m-d", mktime(12...How do i get Solaris 10 x86 installer to install Grub?
Hi I wonder if anyone can help me?
I am new to Solaris. I downloaded the ISO disk image for Solaris 10
(x86) from Sun's website and burned it to a DVD. I booted my PC from
the DVD and chose the interactive install session. 1 hour later all the
files had installed to the partition I'd chosen and the computer reset
however Solaris 10 did not install the Sun version of Grub bootloader.
I currently have Windows XP and Ubuntu Linux installed on my computer
and the Linux Grub bootloader is installed however i read on the Sun
website that only Sun's version of Grub supports the U...Date function to get date of Monday of current week
I need to select from a table where a date column is greater than
Monday's date of the current week.
I see a lot of date functions but don't see any that addresses this
Anyone know of a good way of doing this?
Thanks in advance.
On 17-5-2009 18:20, vbhavsar wrote:
> I need to select from a table where a date column is greater than
> Monday's date of the current week.
> I see a lot of date functions but don't see any that addresses this
> particular requirement.
> Anyone know of a good way of doing this?
So...Cant Get a Date Field to return correct date?
Right i have tried but failed!
I have a Form and a subform
Fields in Sub form are:-
Planned - Checkbox
Unplanned - Checkbox
Maint Type - Dropdown selection
Completed - Checkbox
Fields in Main form are:-
Then i have four groups of Maintenance types
Pressure Test - with a Yes and No selection (Yes property = 36 No =0)
NDT Test- with a Yes and No selection.
Basically I want the Next due date field to look at the maintenance
type Eg. "Pressure Test" and the date done and add 36 and give me a
d...Get the date time from Oracle date time stamp?????
I am using crystal reports to attempt to extract information from this
database but I need to know which records were last updated. I have
managed to find a field in Oracle and its value is based on a trigger
function as shown below
select TIMESTAMP_SEQ.nextval into :new.NURS_TIMESTAMP from dual;
This at 9.45am (UK) on 05/09/2003 generated a value of 5,048,868
My main expertise is in SQL Server, my question is can I reverse
engineer this value to calculate the time? Or is it like an identity
field in SQL server (i.e. An automatic incremental counter)
...Online Singles Dating
The singles find-no so interesting and terrible enter in date. By the
way, for some that do not be well of age, they anticipate the day they
will quiz the romantic adults of things for converse about, but with
the Internet, they should not expect that a much time more. Online
unmarried people dating can be about fun specially with the knowledge
that you are not seen, and you can express romantic feelings to
another party without have that physically possess to him.
A bit ashamed to post this question, but the bruise on my forehead is
threatening to obscure my vision ..
I need to get the date in what bash would do as 'date+%d%m%y', and I did
it once about a year ago, but the machine on which the code is present,
I tried this ..
my $date = (system "date"+%d%m%y) ;
print $date ;
... and it gives me '-1' ...
Google doesn't help, either. Thanks in advance.
perldoc -f localtime
Graham Gough <firstname.lastname@example.org> wrote:
> perldoc -f localtime
That probably is what I'm looking for,...How to get the date again?
Dear all, I want to ask one question.
In the Excel file, there are 2 columns, one is the date and the
other one is prices. I use XLSREAD function to import the data to
Matlab and then there are only one column, the price. How can I obtain
the date once again?
James <email@example.com> wrote in message <firstname.lastname@example.org>...
> Dear all, I want to ask one question.
> In the Excel file, there are 2 columns, one is the date and the
> other one is prices. I use XLSREAD function to import the data to
Is there a way to tell when a system was installed?
My thoughts were that there is some file somewhere that is created on
install and never changes. Or there is some entry in some file where
the install timestamp is placed.
Is it possible to find this information or am I destined to failure?
In article <email@example.com>,
NipplePincher <firstname.lastname@example.org> wrote:
>Is there a way to tell when a system was installed?
>My thoughts were that there is some file somewhere that is created on
>install and never changes. Or there is some entry...Re: Getting most recent date and closes date #3 1562036
I'm sure there are many ways to do what you want. The following is just
one of those:
input ID DATE date9.;
format date date9.;
proc sort data=have;
by id descending date;
data want (keep=id closes_date most_recent_date diff_days);
format closes_date most_recent_date date9.;
if first.id then counter=0;
if ...Re: Getting most recent date and closes date #3 686261
this example has 20M observations and 20,000 IDs not as slow as I
might have expected. If your IDs are grouped you can use BY in place
of CLASS and the SUMMARY will be faster.
421 proc plan seed=43159083;
NOTE: At the start of processing, random number seed=43159083.
422 factors id=200000 date=100 of 365 / noprint;
423 output out=work.test;
424 format date date9.;
NOTE: The data set WORK.TEST has 20000000 observations and 2 variables.
NOTE: At the end of processing, random number seed=1096940810.
NOTE: PROCEDURE PLAN used (Total process time):
...I get only USA Date format in CLP! What to do to get local format?
I use DB2 8.1 with FixPack 5. In command line for sql I get all DATE
columns only in MM-DD-YYYY format. Of course, DATE('20-12-2003') gives
me an error
SQL0181N The string representation of a datetime value is out of
My db config is:
Database territory = RU
Database code page = 1251
Database code set = 1251
Database country/region code = 7
How to get dates in local format?
Here is a basic script you can ...[News] Getting Linux Installed Without a CD Gets Even Easier
,----[ Quote ]
| UNetbootin allows for the installation of Ubuntu, Fedora, Mandriva, OpenSuse,
| Arch Linux, or Debian to a real partition, so it's no different from a
| standard install, only it has the advantage that it needs no CD. This is
| meant for people who want to install Ubuntu, Fedora, Mandriva, OpenSuse, Arch
| Linux, or Debian but don't have a CD-R to burn, lack a CD writer, or they
| want to install on a computer that doesn't have a CD-ROM drive, like an
| ultra-portable laptop.
Vis...How to get julian date for today's date in AS400 SQL?
Thank you in advance!
On 03 Jul 2013 12:14, Lin Lin wrote:
> How to get julian date for today's date in AS400 SQL?
A /date/ is just an integer value representing an offset within a
Gregorian calendaring system. To get a formatted date _string_ from the
SQL, use the CHAR() casting scalar function, with the second argument
specifying the "local" if\when the SQL environment has been established
to have its Date Format preference (SQL Option DATFMT) set to use the
so-called "Julian" format which may have been inherited from the
DatFmt() for the job....Can we get Oracle to drop the Ask Toolbar installation during installing Java?
I wrote a module
that converts the date found in the filename of a picture
taken with a Sony-Ericsson P800 camera phone to a DateTime
object. It has nothing to do with EXIF. The date in the
filename consists of four characters and is almost
Y year between 2000 and 2035, 0-9A-Z
M month, 0-9AB
D day of month, 0-9A-U
H hour of day, 0-9A-N
Using this I can find the hour the picture is taken when the
timestamp of the file in the filesystem is not the ...Getting "date" command to output the date in milli-seconds
Can anyone tell me if it is possible to get the AIX "date" command to output
current time down to milli-seconds. A review of the man pages shows how to
output time only as accurately as seconds.
I need this to log the start time of a regularly called script. This script
properly only when ran as single instance. I had problems with a remote host
calling this twice within a second of each other. Some kind of scheduler
on the calling side.
I have implemented a lock file locking mechanism to stop this happening in
future, but I would like to be able to log the...