Sponsored Content
Operating Systems AIX Change specific (not current) date to timestamp Post 302509649 by Hyperborejac on Thursday 31st of March 2011 11:05:35 AM
Old 03-31-2011
Here is the problem:

I have file. Lines in file looks something like this (I remove extra strings):

Mar 29 06:59:00 2011 (this is not current time!)
Mar 29 09:59:00 2011
Mar 29 19:59:00 2011
etc...

What I need to do is to transform date and time from line to unix timestamp and save it as a string in variable. In bash, this is not hard, because date command have -d option that does exactly this:
...
FIRST_TIMESTAMP=`date +%s -d"$first_line"`
SECOND_TIMESTAMP=`date +%s -d"$second_line"`
...

So, this is what I need and it worked without problem. But, in AIX, date command doesn't have -d option. If I try to execute: "date +%s" that will work as expected, but only for current date and time. I couldn't find a way to tell him: I want this specific time to transform to timestamp. I hope that I was clearer now.

By the way, I read linked post from first answer and I couldn't find what I needed (maybe I missed it in reading, but I doubt). I also need bash to do this (no perl or asking Informix database, as one of the posters suggest in his solution). Thanks in advance!


P.S. I used awk in first post because line look slightly different, so I have to remove some of the columns.
 

10 More Discussions You Might Find Interesting

1. AIX

how to grep and compare timestamp in a file with the current date

I want to read a log file from a particular location.In the logfile , lines contains timestamp.I need to compare the timestamp in the logfile with the current date.If the timpestamp in the log file is less than 4 hours then i need to read the file from that location.Below is the file format.Please... (1 Reply)
Discussion started by: achu
1 Replies

2. AIX

how to grep and compare timestamp in a file with the current date

I want to read a log file from a particular location.In the log file each line starts with timestamp.I need to compare the timestamp in the logfile with the current date.If the timpestamp in the log file is less than 4 hours then i need to read the file from that location.Below is the file... (1 Reply)
Discussion started by: achu
1 Replies

3. Shell Programming and Scripting

Compare file timestamp with current date. Diff must be 1 hour.

Hello, I've created the script below to compare the content of two files with a delay of an hour. After an hour, the lines that exist in both files, will be printed and executed. The script now uses a counter to countdown 50 minutes. But what I would prefer is to check the file timestamp of... (3 Replies)
Discussion started by: taipan
3 Replies

4. UNIX for Advanced & Expert Users

In ksh find out the timestamp of current date?

Normally we can use %s to find out the time in second since 1970. But in my ksh, this format option is not available. Example- date +%s 1268103151 above script command won't work in ksh. Can you guys provide its equivalent ? (3 Replies)
Discussion started by: boy18nj
3 Replies

5. Shell Programming and Scripting

Check if a date field has date or timestamp or date&timestamp

Hi, In a field, I should receive the date with time stamp in a particular field. But sometimes the vendor sends just the date or the timestamp or correctl the date&timestamp. I have to figure out the the data is a date or time stamp or date&timestamp. If it is date then append "<space>00:00:00"... (1 Reply)
Discussion started by: machomaddy
1 Replies

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

7. UNIX and Linux Applications

Reflection Macro: Use Current Date Information in specific field of report

Hi Everyone, New to the forum, and have my first question. I have the following Macro currently being used within Telnet to run a report for the date being entered. However, now I need the Macro to input the day after today to the the day after today. Example: If today is May 9, 2012 - the... (0 Replies)
Discussion started by: CipherEffect
0 Replies

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

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

10. UNIX for Beginners Questions & Answers

How to change existing date to current date in a filename?

Suppose i have a list of files in a directory as mentioned below 1. Shankar_04152019_ny.txt 2. Gopi_shan_03122019_mi.txt 3. Siva_mourya_02242019_nd.txt .. . . . . 1000 . Jiva_surya_02282019_nd.txt query : At one shot i want to modify the above all filenames present in one path with... (4 Replies)
Discussion started by: Shankar455
4 Replies
DATE_SUNSET(3)								 1							    DATE_SUNSET(3)

date_sunset - Returns time of sunset for a given day and location

SYNOPSIS
mixed date_sunset (int $timestamp, [int $format = SUNFUNCS_RET_STRING], [float $latitude = ini_get("date.default_latitude")], [float $longitude = ini_get("date.default_longitude")], [float $zenith = ini_get("date.sunset_zenith")], [float $gmt_offset]) DESCRIPTION
date_sunset(3) returns the sunset time for a given day (specified as a $timestamp) and location. PARAMETERS
o $timestamp - The $timestamp of the day from which the sunset time is taken. o $format - $format constants +-----------------------+-------------------------------------------+ | constant | | | | | | | description | | | | | | example | | | | +-----------------------+-------------------------------------------+ | SUNFUNCS_RET_STRING | | | | | | | returns the result as string | | | | | | 16:46 | | | | | SUNFUNCS_RET_DOUBLE | | | | | | | returns the result as float | | | | | | 16.78243132 | | | | |SUNFUNCS_RET_TIMESTAMP | | | | | | | returns the result as integer (timestamp) | | | | | | 1095034606 | | | | +-----------------------+-------------------------------------------+ o $latitude - Defaults to North, pass in a negative value for South. See also: date.default_latitude o $longitude - Defaults to East, pass in a negative value for West. See also: date.default_longitude o $zenith - Default: date.sunset_zenith o $gmtoffset - Specified in hours. ERRORS
/EXCEPTIONS Every call to a date/time function will generate a E_NOTICE if the time zone is not valid, and/or a E_STRICT or E_WARNING message if using the system settings or the $TZ environment variable. See also date_default_timezone_set(3) CHANGELOG
+--------+---------------------------------------------------+ |Version | | | | | | | Description | | | | +--------+---------------------------------------------------+ | 5.1.0 | | | | | | | Now issues the E_STRICT and E_NOTICE time zone | | | errors. | | | | +--------+---------------------------------------------------+ RETURN VALUES
Returns the sunset time in a specified $format on success or FALSE on failure. EXAMPLES
Example #1 date_sunset(3) example <?php /* calculate the sunset time for Lisbon, Portugal Latitude: 38.4 North Longitude: 9 West Zenith ~= 90 offset: +1 GMT */ echo date("D M d Y"). ', sunset time : ' .date_sunset(time(), SUNFUNCS_RET_STRING, 38.4, -9, 90, 1); ?> The above example will output something similar to: Mon Dec 20 2004, sunset time : 18:13 SEE ALSO
date_sunrise(3). PHP Documentation Group DATE_SUNSET(3)
All times are GMT -4. The time now is 01:41 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy