Sponsored Content
Full Discussion: Problem with Timestamp
Top Forums Shell Programming and Scripting Problem with Timestamp Post 302929653 by bhaskar v on Wednesday 24th of December 2014 01:25:10 AM
Old 12-24-2014
Problem with Timestamp

Hi Team,

i need some help on finding one hour back time.
if current time is 5:18:22 means i have to find 4:18:22
i am having scenario to pull record which as got inserted morethan one hour back
in table time stamp is 2014-12-22 05:15:13.788875

can any one help me on this


Thanks
Vij

Last edited by Don Cragun; 12-24-2014 at 02:55 AM.. Reason: Get rid of COLOR tags; change HTML tags to ICODE tags.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

timestamp problem

hi, from a shell script I am copying 2 different set of files in 2 different directories and then it ftp the same set files to another server 2 different directories. the dest directories where it is copying the files own by a different user and required permission is there... (0 Replies)
Discussion started by: sankar
0 Replies

2. Programming

timestamp conversion problem.

Hi all. I have the following code: #include<stdio.h> #include<time.h> int main() { struct tm tm; time_t time = 1262322000; /*Jan, 01, 2010*/ char temp; int i = 0; while(i < 4) { memset(temp, 0, 128); localtime_r(&time,... (2 Replies)
Discussion started by: adm1n
2 Replies

3. Shell Programming and Scripting

Getting a relative timestamp from timestamp stored in a file

Hi, I've a file in the following format 1999-APR-8 17:31:06 1500 3 45 1999-APR-8 17:31:15 1500 3 45 1999-APR-8 17:31:25 1500 3 45 1999-APR-8 17:31:30 1500 3 45 1999-APR-8 17:31:55 1500 3 45 1999-APR-8 17:32:06 1500 3 ... (1 Reply)
Discussion started by: vaibhavkorde
1 Replies

4. UNIX for Dummies Questions & Answers

Appending timestamp problem

Hi, I am trying to insert a timestamp after all the file names in a folder,after the timestamp is created in the filename the file size is becoming zero bytes. please tell me where I am doing it wrong. I have declared the variable in starting of my script. timestamp=`date... (1 Reply)
Discussion started by: shruthidwh
1 Replies

5. UNIX for Dummies Questions & Answers

How to compare a file by its timestamp and store in a different location whenever timestamp changes?

Hi All, I am new to unix programming. I am trying for a requirement and the requirement goes like this..... I have a test folder. Which tracks log files. After certain time, the log file is getting overwritten by another file (randomly as the time interval is not periodic). I need to preserve... (2 Replies)
Discussion started by: mailsara
2 Replies

6. Shell Programming and Scripting

Identifying files with a timestamp greater than a given timestamp

I need to be able to identify files with file timestamps greater than a given timestamp. I am using the following solution, although it appears to compare files at the "seconds" granularity and I need it at the milliseconds. When I tested my solution, it missed files that had timestamps... (3 Replies)
Discussion started by: nkm0brm
3 Replies

7. UNIX for Dummies Questions & Answers

Timestamp problem

I have a date/timestamp problem I can't figure out. I have an Oracle table with a column DEL_TIMESTAMP defined as a NUMBER. The min and max values in the column are: 6.3417E+17 6.3470E+17 the bottom value is: 634700000000000000 Is this the time since the epoch? How does this represent... (2 Replies)
Discussion started by: djehres
2 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

AIX : Need to convert UNIX Timestamp to normal timestamp

Hello , I am working on AIX. I have to convert Unix timestamp to normal timestamp. Below is the file. The Unix timestamp will always be preceded by EFFECTIVE_TIME as first field as shown and there could be multiple EFFECTIVE_TIME in the file : 3.txt Contents of... (6 Replies)
Discussion started by: rahul2662
6 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
HYLAFAX-SHUTDOWN(5F)													      HYLAFAX-SHUTDOWN(5F)

NAME
etc/shutdown - server shutdown control file DESCRIPTION
If the file etc/shutdown is present it describes when a HylaFAX server is to be shutdown and may contain a descriptive message to return to clients explaining the reason for the shutdown. This file is used by the hfaxd(8C) program. The file has the following format: <year> <month> <day> <hour> <minute> <deny> <disconnect> <shutdown message text> The first line defines the date and time the server should be shutdown and the time preceding at which unprivileged clients should be denied service or disconnected; these fields are described in more detail below. Any lines that follow the first are taken as the text of a message to return to clients when notifying them of a scheduled shutdown or when denying them service. <year> The decimal year; e.g. 1996. <month> The decimal month; e.g. 10 for October. <day> The decimal day of the month in the range [1..31]. <hour> The decimal hour since midnight; in the range [0..23]. <minute> The decimal minute after the hour; in the range [0..59]. <deny> The time prior to the shutdown time at which to deny service to unprivileged clients. This value is specified as decimal number in the form HHMM; e.g. 130 for 1 hour and 30 minutes. <disconnect> Time time prior to the shutdown time at which to disconnect unprivileged clients that are logged in to the server. This value is specified as a decimal number in the form HHMM. NOTES
This file is typically created using the ``SHUT'' command supported by hfaxd(8C). SEE ALSO
hfaxd(8C), hylafax-server(5F) January 18, 1996 HYLAFAX-SHUTDOWN(5F)
All times are GMT -4. The time now is 12:34 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy