Get timestamp by 'YYYYMMDD'


 
Thread Tools Search this Thread
Operating Systems Solaris Get timestamp by 'YYYYMMDD'
# 1  
Old 03-29-2010
Data Get timestamp by 'YYYYMMDD'

Hi,
I'd like to get the file timestamp by 'YYYYMMDD' on Solaris 9 9/05.
I can get it on the other UNIX distribution with the following command;
ls -d -l --time-style='+%Y%m%d'$FNAME | awk '{print $6; }'
but cannot get it on Solaris, it comes format error.
Could you give me any advice on this?

# 2  
Old 03-29-2010
You need to install Gnu "ls" to make use of its specific extensions.
# 3  
Old 03-29-2010
try this perl command:

ls |perl -ne'chomp;($d,$m,$y)=(localtime((stat($_))[9]))[3,4,5];printf "$_ %4d%02d%02d\n",$y+1900,$m,$d'

or you can try the stat command, but i'm not sure if it exists in solaris 10.

regards
# 4  
Old 03-29-2010
Elph,

I was playing around with Solaris 10 and came up with this:

ls -E $FNAME | awk '{print substr($6,1,4) substr($6,6,2) substr($6,9,3);}'

not sure if it works with Solaris 9, but you can try it.
# 5  
Old 03-29-2010
Power Many thanks but ...

Dear all, I really appreciated all of your advice.

jlliagre, unfortunately, we cannot install new program on our customer's server with 'crazy' security policy.

rugdog, at my environment we don't have stat command.
Tried perl command and I got this ...
>$FILE 20100230

sdanner, unfortunately, we don't have -E option for list command.
> ls -1RaAdCxmnlhogrtucpFbqisfL@ [files]

I'll try more harder on your tips, but further advice would be so much appreciated.

Thanx,
elph
# 6  
Old 03-29-2010
Code:
ls -l --time-style='+%Y%m%d' | perl -e 'while (<>){chomp;s/\s+/ /g; my @arr=split(" ");print "$arr[-1]\t$arr[-2]\n";}'

I have not checked this on solaris .but its on the assumption that filename is the last column and time is last before

HTH,
PL
# 7  
Old 03-30-2010
Power Still...

Dear datptal, thanks for your kind advice.

Unfortunately, at this environment, we can't use "time-style".
(jlliagre had kindly advised to install GNU but we can't do it due to security reason)

If you have any furthere solution, I'd be so grateful.
Your perl script helped me a lot.

Rgs,
elph
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