Sponsored Content
Top Forums UNIX for Dummies Questions & Answers I want to seperate my data by time of day Post 302280349 by Lakris on Monday 26th of January 2009 03:41:54 PM
Old 01-26-2009
Hi,
You can try something like this first. You can format the datestring so it is easy for You to sort and select from there, maybe redirecting it to a temporary file first


Code:
while read errno unixdate
do 
echo $errno $(date '+%Y-%m-%d-%H.%M.%S' -d @$unixdate)
done < logfile > logfile.tmp

Depending on Your version of date, it *may* not work..
Best regards
/Lakris
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need help to seperate data

Hello ALL, I really need help to grep data and store in particular format. I am struggling to write that script .Please help me to solve this problem otherwise i will loose my job... I have to compare 2 files and generate the staticts of the data. First file product.dat contains 2 column . ... (4 Replies)
Discussion started by: getdpg
4 Replies

2. Shell Programming and Scripting

how to awk a data from seperate lines

Hi guys, i have a problem which im hoping you will be able to help me with. I have follwing output :- ------------------------------------------------------------------------------- NSTEP = 407000 TIME(PS) = 43059.000 TEMP(K) = 288.46 PRESS = 0.0 Etot = -2077.4322 ... (2 Replies)
Discussion started by: Mish_99
2 Replies

3. Shell Programming and Scripting

UNIX -> send data as excel in seperate cells

Hi I have a data file in UNIX as follows. I need to send this file in Mail as excel format. but the problem i face is i get the data all in single cells per row. what can i do to get the data in seperate cells. File -> attachment.xls data data data data data1 data1 ... (1 Reply)
Discussion started by: vj8436
1 Replies

4. Shell Programming and Scripting

awk convert seconds to time of day

Does anyone know of a way to convert "seconds" to time of day in "hh:mm:ss" ? Trying to do in awk with strftime but with no luck. Thanks (2 Replies)
Discussion started by: timj123
2 Replies

5. Shell Programming and Scripting

value of variable based on time of the day

i would need some help in setting the value of a variable (TIME_NOW) depending on the time of the day ...e.g. if today's date is 12th April 2009 and if the current time is between midnight and 16:59:59 hrs then the TIME_NOW should be yesterday's date i.e. TIME_NOW=11 else if the current time... (3 Replies)
Discussion started by: zainravi
3 Replies

6. Shell Programming and Scripting

How to? Every day, same time... script...

I manage to find and proces one script, now i need to automate this script for every day at the same time... (2 Replies)
Discussion started by: voltaza
2 Replies

7. AIX

Time of Day Question

I have a question i need clarification. We had a problem on a p520 system and had to pull the battery on the service processor card. That did the trick and system booted. We forgot to set the time in the service processor before booting. Once AIX was booted we changed the date and time there. ... (1 Reply)
Discussion started by: ryan0911
1 Replies

8. UNIX for Advanced & Expert Users

Need to get the time difference for all the transactions in a day

Hello Experts, I need to evaluate my API performance, so need a script to get the time difference for all the transaction that has gone through my application in a day. The challenge is the multi threaded logs, so I cant just get all the Telephone Numbers and check the entering and existing... (5 Replies)
Discussion started by: samjna
5 Replies

9. Shell Programming and Scripting

Get day of week from epoch time

Need assistance . Below code gives me the date but I wanted output as day of the week (wday) . Code: use Time::Local; my $time=timelocal(1,2,3,9,11,2013); $theTime = localtime($time); print "$theTime\n"; Result: Mon Dec 9 03:02:01 2013 Wanted output as only Mon (2 Replies)
Discussion started by: ajayram_arya
2 Replies
DATE_SUNRISE(3) 							 1							   DATE_SUNRISE(3)

date_sunrise - Returns time of sunrise for a given day and location

SYNOPSIS
mixed date_sunrise (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.sunrise_zenith")], [float $gmt_offset]) DESCRIPTION
date_sunrise(3) returns the sunrise time for a given day (specified as a $timestamp) and location. PARAMETERS
o $timestamp - The $timestamp of the day from which the sunrise 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.sunrise_zenith o $gmtoffset - Specified in hours. RETURN VALUES
Returns the sunrise time in a specified $format on success or FALSE on failure. 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. | | | | +--------+---------------------------------------------------+ EXAMPLES
Example #1 date_sunrise(3) example <?php /* calculate the sunrise time for Lisbon, Portugal Latitude: 38.4 North Longitude: 9 West Zenith ~= 90 offset: +1 GMT */ echo date("D M d Y"). ', sunrise time : ' .date_sunrise(time(), SUNFUNCS_RET_STRING, 38.4, -9, 90, 1); ?> The above example will output something similar to: Mon Dec 20 2004, sunrise time : 08:54 SEE ALSO
date_sunset(3). PHP Documentation Group DATE_SUNRISE(3)
All times are GMT -4. The time now is 05:53 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy