Get timestamp by 'YYYYMMDD'


 
Thread Tools Search this Thread
Operating Systems Solaris Get timestamp by 'YYYYMMDD'
# 15  
Old 03-31-2010
I'm confused by your tests. What I wrote is a ksh script. You apparently named it test.csh but finally run it through the sh interpreter. These are three different scripting languages and their syntax isn't compatible.

Please use a proper extension if you want too (.ksh) and make this script executable. Run it directly by providing its full path and without specifying an interpreter.

eg:
Code:
mv test.csh ls-timestamp.ksh
chmod +x ls-timestamp.ksh
./ls-timestamp.ksh

# 16  
Old 03-31-2010
@elph
Omitting to mention that this is "C shell" environment with Japanese character set has not helped the posters.

Anyone pursuing this post will need an understanding of this environment.
# 17  
Old 03-31-2010
Quote:
Originally Posted by elph
Many thanks for your advise. Here's normal ls -l output at my current environment.

>ls -l test.txt
-rw-r----- 1 jpXXXX appXXXX 0 3月 31日 13:09 test.txt

elph

LC_ALL=C ls -l | perl -e 'my %hash = ( "Jan"=> "01" , "Feb" => "02" , "Mar" => "03" , "Apr" => "04"); # add other months
while (<>){
chomp; s/\s+/ /g;
my @arr=split(" ");
print "$arr[-1]\t";
my $mon_value = $hash{$arr[-4]};
my $day = $arr[-3];
my $date = "2010".$mon_value.$day; # assuming year is 2010 if year present use the appropriate column
print "$date\n";
}'

I dont have solaris or japanese environment Smilie . So may be u can try if this helps. make sure the months specified in the hash are of the format you get in the ls output
# 18  
Old 04-01-2010
Bug Many, many thanks!!

Hi, jlliagre
Sorry for my carzy output last time. Thanks to your script, I got it at last what I'd like to have!
Here's the result for test.txt which was made in March 31.

> ./ls-timestamp.ksh
20100331
(This result was just chanded $@ to target file, "ls test.txt | while read line" and delete "$(ls -ld "$line")"
at the end from your script)

I'll try it to work on C shell for our environment. If I'll have any problems, pls let me post it as other topic.
Thank you so muchSmilie

Hi, daptal
I really appreciated all of your advise. To see your script, I'd lovely to learn perl more and more, which will help us our intentionsSmilie

Hi, methyl
You're right. I'm sure to post the output in universalistic way in my next topicSmilie

Dear all,
That was my first time to post here and so glad to know I was posting the right place.Thanks for all of your attention and advices.

Sincerly,
elph

Last edited by elph; 04-01-2010 at 11:34 AM..
# 19  
Old 04-02-2010
Glad you finally got it and thanks for the feedback.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Grep lines between last hour timestamp and current timestamp

So basically I have a log file and each line in this log file starts with a timestamp: MON DD HH:MM:SS SEP 15 07:30:01 I need to grep all the lines between last hour timestamp and current timestamp. Then these lines will be moved to a tmp file from which I will grep for particular strings. ... (1 Reply)
Discussion started by: nms
1 Replies

2. Shell Programming and Scripting

How to split timestamp and put a dot between YYYYMMDD and HHMMSS?

I have a string time=20170303201234 I want to split it and put a dot result: 20170303.201234 CODE: ttdotss=`echo ${time} | {8}.{8}` Doesn't understand I tried this: CODE: ttdotss=`echo ${time} |cut -c 1-8 | . | cut -c 9-14` Result: script: .: argument expected... (4 Replies)
Discussion started by: digioleg54
4 Replies

3. Shell Programming and Scripting

AIX : Need to convert UNIX Timestamp to normal timestamp

Hello , I am working on AIX. I have to convert Unix timestamp to normal timestamp. Below is the file. The Unix timestamp will always be preceded by EFFECTIVE_TIME as first field as shown and there could be multiple EFFECTIVE_TIME in the file : 3.txt Contents of... (6 Replies)
Discussion started by: rahul2662
6 Replies

4. Shell Programming and Scripting

To check timestamp in logfile and display lines upto 3 hours before current timestamp

Hi Friends, I have the following logfile. Currently time in india is 07/31/2014 12:33:34 and i have the following content in logfile. I want to display only those entries which contain string 'Exception' within last 3 hours. In this case, it would be the last line only I can get the... (12 Replies)
Discussion started by: srkmish
12 Replies

5. Shell Programming and Scripting

Identifying files with a timestamp greater than a given timestamp

I need to be able to identify files with file timestamps greater than a given timestamp. I am using the following solution, although it appears to compare files at the "seconds" granularity and I need it at the milliseconds. When I tested my solution, it missed files that had timestamps... (3 Replies)
Discussion started by: nkm0brm
3 Replies

6. UNIX for Dummies Questions & Answers

How to compare a file by its timestamp and store in a different location whenever timestamp changes?

Hi All, I am new to unix programming. I am trying for a requirement and the requirement goes like this..... I have a test folder. Which tracks log files. After certain time, the log file is getting overwritten by another file (randomly as the time interval is not periodic). I need to preserve... (2 Replies)
Discussion started by: mailsara
2 Replies

7. Shell Programming and Scripting

Getting a relative timestamp from timestamp stored in a file

Hi, I've a file in the following format 1999-APR-8 17:31:06 1500 3 45 1999-APR-8 17:31:15 1500 3 45 1999-APR-8 17:31:25 1500 3 45 1999-APR-8 17:31:30 1500 3 45 1999-APR-8 17:31:55 1500 3 45 1999-APR-8 17:32:06 1500 3 ... (1 Reply)
Discussion started by: vaibhavkorde
1 Replies

8. Shell Programming and Scripting

conversion of different timestamp to standard timestamp

hi i need a scrit to convert one date format to another. for example i have three columns in a file which gets a different format, but lastly i want output with stadard timestamp as "yyyy-mm-dd hh:mm:ss" column1 column2 ... (2 Replies)
Discussion started by: dprakash
2 Replies

9. Shell Programming and Scripting

get yesterday in yyyymmdd format

how can i get yesterday in yyyymmdd format? :confused: (13 Replies)
Discussion started by: aaron_fong
13 Replies

10. Shell Programming and Scripting

Converting YYYYMMDD to Julian

I am writing some PERL code (and I realize this is a UNIX forum), but was wondering if anyone has a quick routine (PERL or shell scripting) to take a date in YYYYMMDD format and return the 3 digit Julian number. For instance, my program will have a variable called "$Settlement_Date" and will... (5 Replies)
Discussion started by: dfran1972
5 Replies
Login or Register to Ask a Question