Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: AIX : Need to convert UNIX Timestamp to normal timestamp
Top Forums Shell Programming and Scripting AIX : Need to convert UNIX Timestamp to normal timestamp Post 302959146 by RavinderSingh13 on Thursday 29th of October 2015 10:14:57 AM
Old 10-29-2015
Hello Rahul,

Could you please try following and let us know if this helps.
Code:
awk '/EFFECTIVE_TIME/{ printf "%s -- %s\n", strftime("%c",$2), $0 }'  Input_file

Output will be as follows.
Code:
Tue Jul 20 10:17:18 2010 -- EFFECTIVE_TIME 1279635438

EDIT: For getting exact time with all the lines in Input_file, you could try following then.
Code:
awk '/EFFECTIVE_TIME/{ printf "%s\n", strftime("%c",$2);next} 1'  Input_file

Output will be as follows.
Code:
Contents of /usr/openv/netbackup/db/class/PRDEWQ_OS/info :
\n
ACTIVE 0
Tue Jul 20 10:17:18 2010
\n
Contents of /usr/openv/netbackup/db/class/PRDEWQ_OS/schedule/Full/days :
\n
0 0 39600
1 0 0
2 0 0
3 0 0
4 0 0
5 0 0
6 0 0
\n
Contents of /usr/openv/netbackup/db/class/PRDEWQ_OS/schedule/Full/info :
\n
\n
Contents of /usr/openv/netbackup/db/class/PRDEWQ_OS/schedule/Incremental/days :
\n
0 0 0
1 0 25200
2 0 25200
3 0 25200
4 0 25200
5 0 25200
6 0 25200
\n
Contents of /usr/openv/netbackup/db/class/PRDEWQ_OS/schedule/Incremental/info :
\n
\n

Thanks,
R. Singh
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

AIX/awk date to unix timestamp

Hello, I am inside a awk script on AIX, I am feeding to awk ls -luNR i need to convert ls -u time format "month day h:m/yr" to Unix epoch time, POSIX time, or aka unix timestamp I do not have strftime funk in my awk, and i have to do this fast meaning that I cannot do a system call in the... (1 Reply)
Discussion started by: nullwhat
1 Replies

2. Shell Programming and Scripting

Convert Unix Timestame to real timestamp

Hello, Did anyone know how to use script (e.g. perl) to conver Unix Timestame to real timestame in GMT+8 ? 1245900787 file:/tmp/a/Test/.txt.swp has created 1245900988 file:/tmp/a/Test/.txt.swp has changed Thu, 25 Jun 2009 11:33:07 GMT+8 file:/tmp/a/Test/.txt.swp has created Thu, 25 Jun... (4 Replies)
Discussion started by: happyday
4 Replies

3. Shell Programming and Scripting

To convert a date(in string format) to unix timestamp

Hi All, I have a string like below. "Mar 31 2009" . I want to convert this to unix time . Also please let me know how to find the unix time for the above string minus one day. For Eg. if i have string "Mar 31 2009" i want to find the unix time stamp of "Mar 30 2009". Thanks in advance,... (11 Replies)
Discussion started by: girish.raos
11 Replies

4. AIX

Convert unix timestamp to year month day format ?

Hello, How do I convert unix timestamp value to 'normal' date format - to get year month and day values ? Looks like it's easy to do using GNU date (linux systems). But how do I do tthis on AIX ? I don't want to write C program, any ways to do that using unix shells ? thanks (1 Reply)
Discussion started by: vilius
1 Replies

5. AIX

convert a specific date to a unix timestamp

hello, i have an AIX5.3 machine and i am writing a script to display some processes. inside the script i want to get the time that the process starts and convert it to a unix timestamp. is there a command that i can use to do that? i search the web but all i found is long scripts and it does... (4 Replies)
Discussion started by: omonoiatis9
4 Replies

6. UNIX for Dummies Questions & Answers

How to convert R$Timestamp in Sql*Plus within a UNIX Shell Script?

I need to compare a R$Timestamp field sql within a Unix Shell Script. In straight SQL the following code works fine: Table Name: LL_UNIT_TRANSACTION UT Field: R$Timestamp Where TRUNC(UT.R$Timestamp) >= TRUNC(SYSDATE -7) the following returns no data within the Unix Shell Script... (2 Replies)
Discussion started by: Dapconsult
2 Replies

7. 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

8. Shell Programming and Scripting

Convert UNIX timestamp to readable format in the file

Hello I have a file : file1.txt with the below contents : 237176 test1 test2 1442149024 237138 test3 test4 1442121300 237171 test5 test7 1442112823 237145 test9 test10 1442109600 In the above file fourth field represents the timestamp in Unix format. I found a command which converts... (6 Replies)
Discussion started by: rahul2662
6 Replies

9. Shell Programming and Scripting

Convert date in dd mm yyyy format to UNIX timestamp

Hello All, I have a date in DD/MM/YYYY format. I am trying to convert this into unix timestamp. I have tried following: date -d $mydate +%s where mydate = 23/12/2016 00:00:00 I am getting following error: date: extra operand `+%s' Try `date --help' for more information. ... (1 Reply)
Discussion started by: angshuman
1 Replies

10. 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

LEARN ABOUT PHP

getdate

GETDATE(3)								 1								GETDATE(3)

getdate - Get date/time information

SYNOPSIS

       array getdate ([int  $timestamp = time()])

DESCRIPTION

	Returns an associative array containing the date information of the $timestamp, or the current local time if no $timestamp is given.

PARAMETERS

	      o $timestamp
		-  The	optional  $timestamp parameter is an integer Unix timestamp that defaults to the current local time if a $timestamp is not
		given. In other words, it defaults to the value of time(3).

RETURN VALUES

	Returns an associative array of information related to the $timestamp. Elements from the returned associative array are as follows:

       Key elements of the returned associative array

       +----------+--------------------------------------+---+
       |   Key	  |					 |   |
       |	  |					 |   |
       |	  |		Description		 |   |
       |	  |					 |   |
       |	  |	  Example returned values	 |   |
       |	  |					 |   |
       +----------+--------------------------------------+---+
       |	  |					 |   |
       |"seconds" |					 |   |
       |	  |					 |   |
       |	  |  Numeric representation of seconds	 |   |
       |	  |					 |   |
       |	  |					 |   |
       |	  |		  0 to 59		 |   |
       |	  |					 |   |
       |	  |					 |   |
       |"minutes" |					 |   |
       |	  |					 |   |
       |	  |  Numeric representation of minutes	 |   |
       |	  |					 |   |
       |	  |					 |   |
       |	  |		  0 to 59		 |   |
       |	  |					 |   |
       |	  |					 |   |
       | "hours"  |					 |   |
       |	  |					 |   |
       |	  |   Numeric representation of hours	 |   |
       |	  |					 |   |
       |	  |					 |   |
       |	  |		  0 to 23		 |   |
       |	  |					 |   |
       |	  |					 |   |
       | "mday"   |					 |   |
       |	  |					 |   |
       |	  | Numeric representation of the day of |   |
       |	  | the month				 |   |
       |	  |					 |   |
       |	  |					 |   |
       |	  |		  1 to 31		 |   |
       |	  |					 |   |
       |	  |					 |   |
       | "wday"   |					 |   |
       |	  |					 |   |
       |	  | Numeric representation of the day of |   |
       |	  | the week				 |   |
       |	  |					 |   |
       |	  |					 |   |
       |	  | 0 (for Sunday) through 6 (for Satur- |   |
       |	  | day)				 |   |
       |	  |					 |   |
       |	  |					 |   |
       |  "mon"   |					 |   |
       |	  |					 |   |
       |	  |  Numeric representation of a month	 |   |
       |	  |					 |   |
       |	  |					 |   |
       |	  |		1 through 12		 |   |
       |	  |					 |   |
       |	  |					 |   |
       | "year"   |					 |   |
       |	  |					 |   |
       |	  | A  full  numeric representation of a |   |
       |	  | year, 4 digits			 |   |
       |	  |					 |   |
       |	  |	   Examples: 1999 or 2003	 |   |
       |	  |					 |   |
       |	  |					 |   |
       | "yday"   |					 |   |
       |	  |					 |   |
       |	  | Numeric representation of the day of |   |
       |	  | the year				 |   |
       |	  |					 |   |
       |	  |					 |   |
       |	  |	       0 through 365		 |   |
       |	  |					 |   |
       |	  |					 |   |
       |"weekday" |					 |   |
       |	  |					 |   |
       |	  | A full textual representation of the |   |
       |	  | day of the week			 |   |
       |	  |					 |   |
       |	  |					 |   |
       |	  |	  Sunday through Saturday	 |   |
       |	  |					 |   |
       |	  |					 |   |
       | "month"  |					 |   |
       |	  |					 |   |
       |	  | A full textual representation  of  a |   |
       |	  | month, such as January or March	 |   |
       |	  |					 |   |
       |	  |					 |   |
       |	  |	  January through December	 |   |
       |	  |					 |   |
       |	  |					 |   |
       |    0	  |					 |   |
       |	  |					 |   |
       |	  |  Seconds since the Unix Epoch, simi- |   |
       |	  | lar  to  the  values   returned   by |   |
       |	  | time(3) and used by date(3).	 |   |
       |	  |					 |   |
       |	  |  System	Dependent,     typically |   |
       |	  | -2147483648 through 2147483647.	 |   |
       |	  |					 |   |
       +----------+--------------------------------------+---+
EXAMPLES

       Example #1

	      getdate(3) example

	      <?php
	      $today = getdate();
	      print_r($today);
	      ?>

	      The above example will output something similar to:

	      Array
	      (
		  [seconds] => 40
		  [minutes] => 58
		  [hours]   => 21
		  [mday]    => 17
		  [wday]    => 2
		  [mon]     => 6
		  [year]    => 2003
		  [yday]    => 167
		  [weekday] => Tuesday
		  [month]   => June
		  [0]	    => 1055901520
	      )

SEE ALSO

       date(3), idate(3), localtime(3), time(3), setlocale(3).

PHP Documentation Group 														GETDATE(3)
All times are GMT -4. The time now is 07:34 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy