How to get current date minus 30 days 1

[bosoxer1]

I have two options. Get unix current date -30 days, and feed that into a db2 where clause, or have the db2 where clause itself get current daye - 30 days, in the format of char 2006051800. 00 can be appended, I hope.

Thanks in advance.

 

[PHV]

Have a look here: faq80-4800
Then you may try this:
GetDate -$((30 \* 24)) '+%Y%m%d00'


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[feherke]

Hi

I know, I know, this is Unix forum and Unix people have no GNU utilities, but anyway. This works with GNU [tt]date[/tt] :

date -d "30 days ago" "+%Y%m%d00"

But I would use the database functions for this.

Feherke.

http://rootshell.be/~feherke/

 

[columb]

Presumably there's no reason, legal or technical, why you can't take the source code of the GNU date and compile it on your own machine.

Ceci n'est pas une signature
Columb Healy

 

[PHV]

But I would use the database functions for this
I obviously totally agree !

 

[vgersh99]

I personally like the Julian date converstion logic

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+