Problem to get yesterday's date flatfile with shell script


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Problem to get yesterday's date flatfile with shell script
# 15  
Old 10-06-2009
TZ means time zone.... and MYT is your local time.. 16 is difference from GMT to get yesterday date...
and your are taking it into variable so it would not override default time zone.

you can run in cron also but i am not very familier with cron.
# 16  
Old 10-07-2009
Hi
do i need to change the 16 value every year?
Thanks!

---------- Post updated 10-07-09 at 10:24 AM ---------- Previous update was 10-06-09 at 02:17 PM ----------

Hi Sandeep,

i will get the flatfile from my server to another server which reside in my country also, so do i need to follow GMT?
let say i run the cronjob at oct 10 at 4 am, can i set the TZ=MYT+6, which is oct 9?
Thanks!
# 17  
Old 10-07-2009
hi,

you can use the TZ variable to match your server timings.. but if you want exactly the same time and date yesterday, you have to use TZ=MYT+16..

if i am not wrong MYT is malaysian time... if it is GMT+8hrs... now to get Ydate you need to use MYT+(24-8).

jus send the output of "date" command and "echo `TZ=MYT+16 date`"

if you directly use TZ=MYT+16 date at prompt , your default time will be override because TZ is a environmental variable. so better to take into some temp variable.

i hope i was clarified.

Last edited by sandeep909; 10-07-2009 at 01:28 AM..
# 18  
Old 10-07-2009
Hi Sandeep,

i got 1 more last question, my shell script as below: If i run it thru cronjob everyday, will it override my default time zone? Also what is mean by temp variable?
Thanks!

#!/bin/sh
HOST='192.100.93.12'
USER='user'
PASSWD='password'
LDIR='/PROD'
FILE='accmgt'
YDAY=`TZ=MYT+12 date '+%Y%m%d'`

ftp -n $HOST <<END_SCRIPT
quote USER $USER
quote PASS $PASSWD
lcd $LDIR
bin
prompt
mget $FILE$YDAY*.txt
quit
END_SCRIPT
exit 0
# 19  
Old 10-08-2009
hi,

what i mean by temp variable is nothing but YDAY in your script.. and your default time zone will not be override as your are using now.

and in script ftp block might not work.. Replace with below block and try

Code:
 
ftp -inv $HOST <<END_SCRIPT
user $USER $PASSWD
cd $LDIR
bin
prompt
mget $FILE$YDAY*.txt
bye
END_SCRIPT


Last edited by sandeep909; 10-08-2009 at 01:23 AM..
# 20  
Old 10-08-2009
Tools

Code:
date '+%d%m%Y' --date '1 day ago'

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell script to compare two files of todays date and yesterday's date

hi all, How to compare two files whether they are same are not...? like i had my input files as 20141201_file.txt and 20141130_file2.txt how to compare the above files based on date .. like todays file and yesterdays file...? (4 Replies)
Discussion started by: hemanthsaikumar
4 Replies

2. Shell Programming and Scripting

How to append date to filename, but base it on yesterday's date?

Hello, I'd like to write a monthly archive script that archives some logs. But I'd like to do it based on yesterday's date. In other words, I'd like to schedule the script to run on the 1st day of each month, but have the archive filename include the previous month instead. Here's what I... (5 Replies)
Discussion started by: nbsparks
5 Replies

3. Shell Programming and Scripting

How to get tomorrow,yesterday date from date Command

Hi I want to get tomorrow and yesterday date from date command. My shell is KSH and server is AIX. I tried several options, but unable to do. Please help on this. Regards Rajesh (5 Replies)
Discussion started by: rajeshmepco
5 Replies

4. Shell Programming and Scripting

[Solved] Replace yesterday date with today's date except from the first line

Hello, I have a file like this: 2012112920121130 12345620121130msABowwiqiq 34477420121129amABamauee e7748420121130ehABeheheei in case the content of the file has the date of yesterday within the lines containing pattern AB this should be replaced by the current date. But if I use... (3 Replies)
Discussion started by: Lilu_CK
3 Replies

5. Shell Programming and Scripting

Need help in Shell Script comparing todays date with Yesterday date from Sysdate

Hi, I want to compare today's date(DDMMYYYY) with yesterday(DDMMYYYY) from system date,if (today month = yesterday month) then execute alter query else do nothing. The above requirement i want in Shell script(KSH)... Can any one please help me? Double post, continued here. (0 Replies)
Discussion started by: kumarmsk1331
0 Replies

6. Shell Programming and Scripting

Getting yesterday's date in shell script

Im in EST, and im using the command CurrentDate=`TZ="EST+24" date +'%y%m%d'` to get the yesterday's date. Does this work perfectly for the boundary conditions of month end or year end(leap year) etc ? (2 Replies)
Discussion started by: prasperl
2 Replies

7. Shell Programming and Scripting

Deleting a line from a flatfile using Shell Script

Hi All, Can Anyone please tell me,how can I delete a line from a file. I am reading the file line by line using whil loop and validating each line..Suppose in the middle i found a particular line is invalid,i need to delete that particular line. Can anyone please help. Thanks in advance,... (14 Replies)
Discussion started by: dinesh1985
14 Replies

8. Shell Programming and Scripting

Compare date from db2 table to yesterday's Unix system date

I am currently running the following Korn shell script which works fine: #!/usr/bin/ksh count=`db2 -x "select count(*) from schema.tablename"` echo "count" I would like to add a "where" clause to the 2nd line that would allow me to get a record count of all the records from schema.tablename... (9 Replies)
Discussion started by: sasaliasim
9 Replies

9. Shell Programming and Scripting

Yesterday date script

Hello All, I am using the below script to get yesterday date, but it is giving date of day before yesterday. Right now its 080906 but this code is giving 080904. And my requirement is 080905. #!/bin/sh CurrentDate=`TZ="GMT+24" date +'%y%m%d'` echo $CurrentDate; WHY? Please help.. ... (7 Replies)
Discussion started by: wakhan
7 Replies

10. Shell Programming and Scripting

yesterday date month/date

Hi expert, I want to retrieve yesterday su log. How to calculate and assign variable value ( 06/23 ) in myVariable ? #!/bin/sh myVariable=yesterday date in month/date cat /var/adm/sulog | grep $myVariable > file.txt many thanks! (5 Replies)
Discussion started by: skully
5 Replies
Login or Register to Ask a Question