Print Unix File Timestamp Accurate Down to Seconds
by lokety on Jan.31, 2007, under Posts
As most of us know and need, ls -l shows us detailed information about files in a directory.
someone@somewhere:/opt/mozilla/icons $ ls -l
total 32
-rw-r–r– 1 bin bin 1668 Mar 5 2004 mozicon16.xpm
-rw-r–r– 1 bin bin 2944 Mar 5 2004 mozicon50.xpm
total 32
-rw-r–r– 1 bin bin 1668 Mar 5 2004 mozicon16.xpm
-rw-r–r– 1 bin bin 2944 Mar 5 2004 mozicon50.xpm
Here is a single perl command that can print the timestamp of files with full date and time, accurate down to the seconds:
perl -e ‘foreach(@ARGV){$t =localtime ( ( ( stat ( $_ ) ) [9] ) ); printf(“%-20s %s\n”,$_,$t);}’ *
Replace the asterisk at the end of the command with any filename or wildcard expression you require.
Technorati Tags: unix, perl, ls, timestamp, seconds, date and time, unix file
Related posts:
- Print Yesterday’s Date Using Perl
- Perform Satistical Operations on Columns in CSV Files
- Google Trends and Desktop
4 Comments for this entry
Leave a Reply
Buy Stock Images
iStockphoto.com - Newest Uploads
The world's fastest growing royalty-free stock photography collection
Tree bark and root details Monday, 4 January 2010, 6:20 am
Dry and worn details of a tree bark and rootSource:
iStockphoto.com - Newest Uploads | lokety
Big American Breakfast Sunday, 3 January 2010, 8:25 pm
A large serving of breakfast including steak, bacon, sausages, fries, eggs, tomatoes and toast.Source:
Loading ...
December 1st, 2007 on 03:19
excellent! thanks.
October 1st, 2008 on 17:30
Thanks a lot!!!
March 31st, 2009 on 06:43
I run your script as follows:
Perl -e 'foreach(@ARGV){$t =localtime ( ( ( stat ( $_ ) ) [9] ) );printf("%-20s %s\n",$_,$t);}' /db/u/cru/v*/*/*/*.dbf > timestamp.log 2>&1
It prints fine for some and gives me a weird timestamp for others.
Here is the illustration of simple ls –ltr
And then when I run the perl script
alauqpnc010/db/u/cru/v3/system/CRUU1:CRUU1>ls -ltr *.dbf
-rw-r—– 1 dbucru dba 210771968 Mar 3 13:27 users_01.dbf
-rw-r—– 1 dbucru dba 52436992 Mar 3 13:27 tools_01.dbf à correct timestamp
-rw-r—– 1 dbucru dba 3145736192 Mar 4 04:00 temp_01.dbf à Dec 31 timestamp
-rw-r—– 1 dbucru dba 9438240768 Mar 6 14:02 undotbs.dbf
-rw-r—– 1 dbucru dba 524296192 Mar 6 14:02 system_01.dbf
-rw-r—– 1 dbucru dba 524296192 Mar 6 14:02 sysaux01.dbf
Perl script output
/db/u/cru/v3/index/CRUU1/cru_indexes_01.dbf Wed Dec 31 19:00:00 1969
/db/u/cru/v3/system/CRUU1/sysaux01.dbf Fri Mar 6 14:02:33 2009
/db/u/cru/v3/system/CRUU1/system_01.dbf Fri Mar 6 14:02:33 2009
/db/u/cru/v3/system/CRUU1/temp_01.dbf Wed Dec 31 19:00:00 1969 à incorrect Dec 31 timestamp
/db/u/cru/v3/system/CRUU1/tools_01.dbf Tue Mar 3 13:27:36 2009 à correct timestamp
/db/u/cru/v3/system/CRUU1/undotbs.dbf Wed Dec 31 19:00:00 1969
/db/u/cru/v3/system/CRUU1/users_01.dbf Tue Mar 3 13:27:36 2009
/db/u/cru/v3/table/CRUU1/cru_crystadata_01.dbf Wed Dec 31 19:00:00 1969
/db/u/cru/v3/table/CRUU1/cru_data_01.dbf Wed Dec 31 19:00:00 1969
/db/u/cru/v3/table/CRUU1/cru_dellogimage.dbf Tue Mar 3 13:27:36 2009
/db/u/cru/v3/table/CRUU1/result_datapart01.dbf Wed Dec 31 19:00:00 1969
/db/u/cru/v3/table/CRUU1/result_datapart02.dbf Wed Dec 31 19:00:00 1969
/db/u/cru/v3/table/CRUU1/result_datapart03.dbf Wed Dec 31 19:00:00 1969
/db/u/cru/v3/table/CRUU1/result_datapart04.dbf Wed Dec 31 19:00:00 1969
/db/u/cru/v3/table/CRUU1/result_datapart05.dbf Wed Dec 31 19:00:00 1969
/db/u/cru/v3/table/CRUU1/result_datapart06.dbf Wed Dec 31 19:00:00 1969
/db/u/cru/v3/table/CRUU1/result_datapart07.dbf Wed Dec 31 19:00:00 1969
/db/u/cru/v3/table/CRUU1/result_datapart08.dbf Wed Dec 31 19:00:00 1969
February 22nd, 2010 on 12:19
Vikas
It looks like not only temp_01.dbf is showing the wrong year, but a number of other datafiles are affected. Perhaps you can try running the command after this oracle instance is dismounted and/or closed?