Sponsored Content
Top Forums Shell Programming and Scripting Date string conversion within a file Post 302422881 by chrissycc on Wednesday 19th of May 2010 04:37:26 PM
Old 05-19-2010
Date string conversion within a file

Hi,

I have a log file that contains information along the lines of the following:

Code:
=========
jobnumber    322761
start_time   Tue May 19 19:42:37 2009
end_time     Tue May 19 20:11:28 2009
failed       0
=========
jobnumber    322762
start_time   Tue May 19 19:39:51 2009
end_time     Tue May 19 20:28:44 2009
failed       0
=========
jobnumber    322763
etc

The file(s) may contain tens of thousands of records. I want to convert the date string to unix time (secs since 1970 blah), i.e. date -d "Tue May 19 20:28:44 2009" +%s

So the output I want is:

Code:
=========
jobnumber    322761
start_time   1242758557
end_time     1242760288
failed       0
=========
jobnumber    322762
start_time   1242758391
end_time     1242761324
failed       0
=========
jobnumber    322763
etc

Any ideas?

Many thanks!

Last edited by Scott; 05-19-2010 at 07:03 PM.. Reason: Code tags please...
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

date conversion

how do we convert gregorian date to julian date. is there a function in Cshell which can do this sunil (3 Replies)
Discussion started by: sunil bajaj
3 Replies

2. UNIX for Advanced & Expert Users

Date Conversion

Hello, I want to convert MM DD YYYY date format to MM-DD-YYYY format. For exemple: I have to convert Nov 28 2005 to 28-11-2005. Thenks for youf help. DAFI (2 Replies)
Discussion started by: dafidak
2 Replies

3. Shell Programming and Scripting

date conversion

Hi everybody: Could anybody tell me how I convert from a julian date, with shell comands, to gregorian. Thanks in advance. (2 Replies)
Discussion started by: tonet
2 Replies

4. Shell Programming and Scripting

Conversion of date to Julian date

Hi Gurus, Need help in Conversion of date(2007-11-30) to Julian date(YYDDD)... '+%J' 2007-11-30 to 'YYDDD' Thanks (4 Replies)
Discussion started by: SeenuGuddu
4 Replies

5. UNIX for Advanced & Expert Users

Date Conversion on output string from awk

Hi, I would like to convert the output from awk function to date and print on the screen. Example : echo "Start Date: May 24 2010" | gawk -F": " '{print $2}' Output : May 04 2010 I want this to be converted to 2010/05/24 Can i use date function here and how? Thanks, Deepika (2 Replies)
Discussion started by: deepikad
2 Replies

6. Shell Programming and Scripting

Julian date to Calendar date conversion

Hi all, I require to convert julian date to normal calander date in unix for eg julian date=122 now i want corresponding calander date ---------------------------------------- gr8 if give very small command/script and please explain the steps as well(imp) Thanks ... (3 Replies)
Discussion started by: RahulJoshi
3 Replies

7. Shell Programming and Scripting

perl : number to date conversion in CSV file

I have a CSV file in the below format. while generating CSV file from excel sheet , date in excel sheet(Format :Mon 8/28/2012) got converted into the below format with numbers 41148,41149 so on. Could anyone please let me know how to the convert the numbers(41148,41149 so on.) to its actual... (2 Replies)
Discussion started by: giridhar276
2 Replies

8. Shell Programming and Scripting

String to Date conversion

Hi, I have a String say 20131224 which represents a date. I want to to subtract 1 day from this. Any idea how can i do this on AIX. (1 Reply)
Discussion started by: RahulM
1 Replies

9. Shell Programming and Scripting

Date conversion DD-MMM-YY to YYYYMMDD for many columns in a file

Hi, Input Col1|col2|col3|col4|col5|col6-------col26 1|2|3|10-Nov-67|10-Nov-97|4|5-------100 1|2|3|11-Feb-01|01-Dec-15|4|5-------2000 Output Col1|col2|col3|col4|col5|col6-------col26 1|2|3|19671110|19971010|4|5-------100 1|2|3|20010211|20151201|4|5-------2000 I want to convert... (3 Replies)
Discussion started by: onesuri
3 Replies

10. UNIX for Beginners Questions & Answers

Date conversion

Hi , we have a string with yyyymmdd format . how to know which date it is ? example:20120712-->sunday 20150228-->saturday 20140431-->invalid please suggest commands which work on below os : SunOS 5.10 shell: bash shell Thanks, Srinath. (10 Replies)
Discussion started by: srinadhreddy27
10 Replies
time_lock_es(3) 					     Library Functions Manual						   time_lock_es(3)

NAME
time_lock_es - Check time-of-day locking (Enhanced Security) LIBRARY
Security Library (libsecurity.so) SYNOPSIS
#include <sys/types.h> #include <sys/security.h> #include <prot.h> int time_lock_es ( struct es_passwd *prpwd ); PARAMETERS
Specifies a protected password entry structure. DESCRIPTION
The time_lock_es() function performs time-of-day lock checking for the current date and time against the time-of-day specification in the fd_tod string of the prpwd parameter. The function returns 1 if the time lock is on and 0 if there is no lock. The fd_tod specification is like that found in the UUCP Systems file. The specification is a comma-separated list of entries. If the cur- rent time matches an entry in the specification, the time lock is not on. The entries are scanned until a match is found. If no match can be found, the time lock is on. Each entry appears as follows: <day><start_time-end_time> The day is one of the following: Matches any day of the week. Matches Monday through Friday. Sunday Monday Tuesday Wednesday Thursday Friday Saturday The times are military time, for example, 9:15 am is 0915, 6:00 pm is 1800, and 12:42 am is 0042. When start_time is less than end_time, the range of times contains valid times in which to log in that day. When the times are equal or there is only one time (including no time at all), the entire day is valid. When start_time is later than end_time, times outside the range are valid. For instance, if start_time is 04:15 and end_time is 02:00, then any time that falls outside the range of 02:00 to 04:15 is a valid time. NOTES
Programs using this function must be compiled with -lsecurity. In order to quickstart a program, the program must be linked as follows: -lsecurity -ldb -laud -lm See the shared library discussion in the Programmer's Guide for more information about using the quickstarting feature. delim off time_lock_es(3)
All times are GMT -4. The time now is 12:03 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy