Date determination

[meetramana]

Does any body have a quick idea about how to determine the date that was 300 days ago from the current date.
300 days is just an example.

I was wondering if there is quick thing that I didn't know.

Thanks

 

[sbrews]

Have a look at this thread: thread52-1352399
There are some examples and links for determinining a past/future date.

 

[olded]

http://www.computing.net/unix/wwwboard/forum/5985.html

 

[stefanwagner]

a) Install postgres
b) create user etc.
c) create database util
d) create script datecalc.sh:

 psql util << EOF
CREATE TABLE u (d DATE);  
INSERT INTO u VALUES (now()); 
SELECT d$1 FROM u; 
DROP TABLE u;
EOF

run it like this:

 sh datacalc.sh -300

No bad idea, if a-c are already done.
With oracle, the magic dual-table should allow something like that:

select sysdate-300 from dual;

How to invoke a single ora-statement from shell has left my brain.
On Vista-Ultimate, you could easily do it with 217 mouseclicks, and access.

don't visit my homepage:

http://home.arcor.de/hirnstrom/bewerbung

 

[feherke]

Hi

How to invoke a single ora-statement from shell has left my brain.

echo 'select sysdate-300 from dual;' | sqlplus -S [green][i]username[/i][/green]/[green][i]password[/i][/green]@[green][i]database[/i][/green]

Feherke.

http://rootshell.be/~feherke/

 

[mrn]

try date -d

or

perl -e
'@T=localtime(time-86400);printf("%02d/%02d/%02d",$T[4]+1,$T[3],($T[5]+1900) %100)'

where 86400 is seconds ago

300 days = 25920000 seconds

Mike

"Whenever I dwell for any length of time on my own shortcomings, they gradually begin to seem mild, harmless, rather engaging little things, not at all like the staring defects in other people's characters."

 

[meetramana]

perl -e '@y=localtime(time - 86400 * 7 );printf "%s-%02d-%-02d\n",$y[5]+1900,$y[4]+1,$y[3];'

This works,
But How can I automate the with variable something similar to

perl -e '@y=localtime(time - 86400 * $DAYS );printf "%s-%02d-%-02d\n",$y[5]+1900,$y[4]+1,$y[3];'

 

[meetramana]

I got it.

perl -e '@y=localtime(time() - 86400 * $ARGV[0] );printf "%s-%02d-%-02d\n",$y[5]+1900,$y[4]+1,$y[3];' $DAYS

 

[PHV]

Another way:
perl -e '@y=localtime(time - 86400 * [!]'[/!]$DAYS[!]'[/!] );printf "%s-%02d-%-02d\n",$y[5]+1900,$y[4]+1,$y[3];'

In your shell man page have a look at the "quoting" section.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[meetramana]

Thats even shorter and works.

Thankyou