Sponsored Content
Top Forums Shell Programming and Scripting Help needed with date compare Post 302810173 by franzpizzo on Tuesday 21st of May 2013 10:48:26 AM
Old 05-21-2013
Hi, if you want only the records with my_expr_tmstp in the previous day change the script in this way:
Code:
select my_id, my_expr_tmstp from MY_SCHEMA.MY_TABLE 
where my_expr_tmstp = trunc(current_timestamp)-1 ;

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Compare date from db2 table to yesterday's Unix system date

I am currently running the following Korn shell script which works fine: #!/usr/bin/ksh count=`db2 -x "select count(*) from schema.tablename"` echo "count" I would like to add a "where" clause to the 2nd line that would allow me to get a record count of all the records from schema.tablename... (9 Replies)
Discussion started by: sasaliasim
9 Replies

2. Shell Programming and Scripting

Compare Start date and End date...

Hi All, I have problem in my file. It has two date variable. There are 2 variables which has the values as below 1. START_MONTH = “Date(YYYYMM) format” Ex: 201008 2. END_MONTH = “Date(YYYYMM) format” Ex: 201105 The end date should be greater than start date. Now we... (3 Replies)
Discussion started by: suresh01_apk
3 Replies

3. Shell Programming and Scripting

ksh compare dates INSIDE a file (ie date A is > date B)

In KSH, I am pasting 2 almost identical files together and each one has a date and time on each line. I need to determine if the first instance of the date/time is greater than the 2nd instance of the date/time. If the first instance is greater, I just need to echo that line. I thought I would... (4 Replies)
Discussion started by: right_coaster
4 Replies

4. Shell Programming and Scripting

Adding days to system date then compare to a date

Hi! I am trying to read a file and every line has a specific date as one of its fields. I want to take that date and compare it to the date today plus 6 days. while read line do date=substr($line, $datepos, 8) #date is expected to be YYYYMMDD if ; then ...proceed commands ... (1 Reply)
Discussion started by: kokoro
1 Replies

5. Shell Programming and Scripting

Compare Date with String in date format

Hi, I am new to this forum, searched, but for some reason did not find much help, so a new thread. I am trying to compare date with a string which is in date format , but for some reason, system does not give me the right result. Date is coming in a file and i am comparing the same with... (2 Replies)
Discussion started by: mkstool
2 Replies

6. Shell Programming and Scripting

Shell script to compare two files of todays date and yesterday's date

hi all, How to compare two files whether they are same are not...? like i had my input files as 20141201_file.txt and 20141130_file2.txt how to compare the above files based on date .. like todays file and yesterdays file...? (4 Replies)
Discussion started by: hemanthsaikumar
4 Replies

7. Shell Programming and Scripting

Compare the system date with date from a text file

I get the date that's inside a text file and assigned it to a variable. When I grep the date from the file, I get this, Not After : Jul 28 14:09:57 2017 GMT So I only crop out the date, with this command echo $dateFile | cut -d ':' -f 2,4The result would be Jul 28 14:57 2017 GMT How do I... (3 Replies)
Discussion started by: Loc
3 Replies

8. UNIX for Beginners Questions & Answers

Compare date in .txt with system date and remove if it's lesser than system date

Can someone help me with the code wherein there is a file f1.txt with different column and 34 column have expiry date and I need to get that and compare with system date and if expiry date is <system date remove those rows and other rows should be moved to new file f2.txt . I don't want to delete... (2 Replies)
Discussion started by: Stuti
2 Replies

9. Answers to Frequently Asked Questions

Compare date in .txt with system date and remove if it's lesser than system date

I m working on shell scripting and I m stuck where in my .txt file there is column as expiry date and I need to compare that date with system date and need to remove all the rows where expiry date is less than system date and create a new .txt with update. (1 Reply)
Discussion started by: Stuti
1 Replies

10. UNIX for Beginners Questions & Answers

Compare Date to today's date in shell script

Hi Community! Following on from this code in another thread: #!/bin/bash file_string=`/bin/cat date.txt | /usr/bin/awk '{print $5,$4,$7,$6,$8}'` file_date=`/bin/date -d "$file_string"` file_epoch=`/bin/date -d "$file_string" +%s` now_epoch=`/bin/date +%s` if then #let... (2 Replies)
Discussion started by: Greenage
2 Replies
BATTERY-GRAPH(1)					      General Commands Manual						  BATTERY-GRAPH(1)

NAME
battery-graph - Show a graph of the battery charge SYNOPSIS
battery-graph [options] [files...] DESCRIPTION
Show a graph of the battery charge over time. The files given are assumed to contain battery statistics in the battery-stats(5) format. If no files are specified, the default log files will be used. The options can be used for displaying a different interval. An interval is defined in terms of a from timestamp, a to timestamp and a duration. By specifying any two, the third will be calculated automatically. A missing duration will be defaulted to 3 hours. OPTIONS
These programs follow the usual GNU command line syntax, with long options starting with two dashes (`-'). -g geometry, --geometry geometry Sets the X Windows geometry of the graph. This disables text mode. See X(7) for how to specify the geometry. -D display, --display display Shows the graph on the given display. The same effect can be achived by setting the DISPLAY environment variable. This disables text mode. See X(7) for valid values. --title string Sets the title of the graph window. By default this will be "Battery Graph". If this is set to the empty string, gnuplot(1) will be allowed set the window title - this can be useful if you want your ~/.Xdefaults to take effect for this. -f date, --from date Specifies the start date/time for the graph. This accepts exactly the same date/time specifications as the date (1) command - see examples below or the Texinfo manual for date for details. -t date, --to date Specifies the ending date/time for the graph. This accepts exactly the same date/time specifications as the date (1) command - see examples below or the Texinfo manual for date for details. -s date, --since date Shorthand for --from date --to now -d duration, --duration duration Specifies the duration for the graph. This can be given in units of seconds, hours, days or weeks by suffixing the number with 's' (seconds), 'm' (minutes), 'h' (hours), 'd' (days) or 'w' (weeks). Units cannot be combined - e.g. '1d6h' will not be valid, whereas '30h' is OK. If no unit is specified, minutes will be assumed. --text Shows the graph in text mode on stdout. The resulting size of the graph is determined by the values of the environment variables. LINES and COLUMNS (failing that, the output from tput will be used). This is the default when the environment variable DISPLAY is not set. EXAMPLES
Show the last 2 hours: $ battery-graph --duration 2h Show the time since mid day: $ battery-graph --from 12:00 --to now or $ battery-graph --since 12:00 Show the hour before last: $ battery-graph --from '2 hours ago' --duration 1h Show the 6 hours after noon: $ battery-graph --from 12:00 --duration 6h or $ battery-graph --from 12:00 --to 18:00 Show the last 6 hours $ battery-graph --from '6 hours ago' or $ battery-graph --since '6 hours ago' Show the last 30 minutes in text mode: $ battery-graph --duration 30 --text Show statistics for Tuesday last week $ battery-graph --duration 24h --from 'tuesday last week' or $ battery-graph --duration 1d --from 'tuesday last week' Prove that the future hasn't happened yet: $ battery-graph --from yesterday --to tomorrow Another way of wasting CPU cycles: $ battery-graph /dev/null EXIT STATUS
battery-graph depends on gnuplot (1) to give the correct exit status. FILES
If no files are given on the command line, batter-graph reads from /var/log/battery-stats ENVIRONMENT
DISPLAY If this variable is not set, --text will be defaulted. LINES / COLUMNS Determines the size of the graph in text mode. DIAGNOSTICS
If there are no statistics available for the period chosen, an empty graph will result. NOTES
There is no requirement for the from time to be earlier than the to time - if so, the X axis will be reversed. Similar results can be achieved using a negative duration. Also: battery-stat is quite happy to list statistics in the future; stupid, but obedient. AUTHOR
This manual page was written by Karl E. Jorgensen <karl@jorgensen.com>, for the Debian GNU/Linux system (but may be used by others). SEE ALSO
battery-stats (5), date (1), battery-stats-collector (8) Newer versions of this program may (or may not) be available at http://karl.jorgensen.com/battery-stats September 22, 2002 BATTERY-GRAPH(1)
All times are GMT -4. The time now is 12:54 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy