Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Converting string date time to unix time in AWK
Top Forums UNIX for Dummies Questions & Answers Converting string date time to unix time in AWK Post 302688445 by bkkid on Sunday 19th of August 2012 09:25:14 AM
Old 08-19-2012
Converting string date time to unix time in AWK
I'd like to convert a date string in the form of sun aug 19 09:03:10 EDT 2012, to unixtime timestamp using awk.

I tried
This is how each line of the file looks like, different date and time in this format
Sun Aug 19 08:33:45 EDT 2012, user1(108.6.217.236) all: test on the 17th
Through some help here, I was able to add delimiter and make it the way I want
Sun Aug 19 08:33:45 EDT 2012~user1~192.168.1.1~test on the 17t
Code:
 
  awk '/all:/, ............................... print $0 }' file1.txt

I'd like to change the date part fields 1-6 to unixtime like 1344960720~user1~192.168.1.1~messages
I tried various mktime including trying to print the fields
Code:
 {print mktime("$6,$2,$3,$4")}'

. I know I have to remove the : to achieve this, but I tried substituting hh:mm:ss with 11 08 23, still does not work. I get -1 all the times.




help
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Convert Epoch Time to Standard Date and Time & Vice Versa

Hi guys, I know that this topic has been discuss numerous times, and I have search the net and this forum for it. However, non able to address the problem I faced so far. I am on Solaris Platform and unable to install additional packages like the GNU date and gawk to make use of their... (5 Replies)
Discussion started by: DrivesMeCrazy
5 Replies

2. Homework & Coursework Questions

Date comparison with 'string date having slashes and time zone' in Bash only

1. The problem statement, all variables and given/known data: I have standard web server log file. It contains different columns (like IP address, request result code, request type etc) including a date column with the format . I have developed a log analysis command line utility that displays... (1 Reply)
Discussion started by: TariqYousaf
1 Replies

3. Shell Programming and Scripting

Help converting date-time value to decimal

Hi I need help to do some calculation in script. I have a monitor program (munin) that I would like to log uptime information from a server. The script looks like this (not complete): #!/bin/sh # server_uptime ### Config Start # Reads the server parameters using the HTTP port with... (7 Replies)
Discussion started by: Jotne
7 Replies

4. Programming

Converting a user inputted date to epoch time

Hi all , I need to know how to convert a time stamp entered by the user to be converted to GMT/UTC(epoch time) using mktime() and gmtime() for exapample the input will be put in the form ptm.tm_sec = 0; ptm.tm_min = 59; ptm.tm_hour = 11; ptm.tm_mday = 20;... (2 Replies)
Discussion started by: ada
2 Replies

5. Shell Programming and Scripting

Converting date/time and generating offsets in bash script

Hi all, I need a script to do some date/time conversion. It should take as an input a particular time. It should then generates a series of offsets, in both hour:minute form and number of milliseconds elapsed. For 03:00, for example, it should give back 04:02:07 (3727000ms*) 05:04:14... (2 Replies)
Discussion started by: emdan
2 Replies

6. Solaris

modifying date and time and time zone on solaris 5.10 with (redundant server) veritas

I have a cluster of two Solaris server (veritas cluster). one working and the other is standby I am going to change the date on them , and am looking for a secure solution as it is giving an important service. my opinion is that the active one doesn't need to be restarted (if I don't change the... (1 Reply)
Discussion started by: barry1946
1 Replies

7. Shell Programming and Scripting

Adding time to date time in UNIX shell scipting

I needed some help in adding a duration (in seconds) to a start time (in hhmmss format) and a start date (in mmddyy format) in order to get an end date and end time. The concept of a leap year is also to be considered while incrementing the day. The code/ function that I have formed so far is as... (3 Replies)
Discussion started by: codehelp04
3 Replies

8. Shell Programming and Scripting

Displaying current date time of EDT in IST time

Hi Folks, My server time is in EDT. And i am sending automated mails from that server in which i need to display the current date time as per IST (GMT+5:30). Please advice how to display the date time as per IST. IST time leads 9:30 mins to EDT. and i wrote something like below. ... (6 Replies)
Discussion started by: Showdown
6 Replies

9. Shell Programming and Scripting

Converting real time to epoch time

# date +%s -d "Mon Feb 11 02:26:04" 1360567564 # perl -e 'print scalar localtime(1360567564), "\n";' Mon Feb 11 02:26:04 2013 the epoch conversion is working fine. but one of my application needs 13 digit epoch time as input 1359453135154 rather than 10 digit epoch time 1360567564... (3 Replies)
Discussion started by: vivek d r
3 Replies

10. Shell Programming and Scripting

Converting String Date into UNIX Date

Hi, I have a string date to my unix script(sun solaris). I wanted to convert it into unix date so that I can use it in a conditional statement. Please see below: MyTest.sh -s 2018-05-09 suppdt=$1 # string date passed via arguement as 2018-04-09 curryr=`date '+%Y'` nextyr=`expr... (2 Replies)
Discussion started by: Saanvi1
2 Replies

LEARN ABOUT DEBIAN

nqs2pbs

nqs2pbs(1B)								PBS							       nqs2pbs(1B)

NAME

       nqs2pbs - convert NQS job scripts to PBS

SYNOPSIS

       nqs2pbs nqs_script [pbs_script]

DESCRIPTION

       This  utility  converts	a  existing NQS job script to work with PBS and NQS.  The existing script is copied and PBS directives, #PBS , are
       inserted prior to each NQS directive #QSUB or #@$ , in the original script.

       Certain NQS date specification and options are not supported by PBS.  A warning message will be displayed indicating the  problem  and  the
       line of the script on which it occurred.

       If  any	unrecognizable	NQS  directives  are encountered, an error message is displayed.  The new PBS script will be deleted if any errors
       occur.

OPERANDS

       nqs_script
	      Specifies the file name of the NQS script to convert.  This file is not changed.

       pbs_script
	      If specified, it is the name of the new PBS script.   If not specified, the new file name is nqs_script.new .

NOTES

       Converting NQS date specifications to the PBS form may result in a warning message and an incompleted converted date.  PBS does not support
       date  specifications  of  "today",  "tomorrow", or the name of the days of the week such as "Monday".  If any of these are encountered in a
       script, the PBS specification will contain only the time portion of the NQS specification, i.e. #PBS -a hhmm[.ss].   It is  suggested  that
       you specify the execution time on the qsub command line rather than in the script.

       Note that PBS will interpret a time specification without a date in the following way:

       -  If the time specified has not yet been reached, the job will become eligible to run at that time today.

       -  If the specified time has already passed when the job is submitted, the job will become eligible to run at that time tomorrow.

       PBS does not support time zone identifiers.  All times are taken as local time.

SEE ALSO

       qsub(1B)

Local																       nqs2pbs(1B)
All times are GMT -4. The time now is 05:55 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy