Compare a date (mm/dd/yyyy) with awk Post: 303035661

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Date Vadidation in YYYY-MM-DD

Date Vadidation in YYYY-MM-DD Hi , Please, Help me in validating given date that is passed in arg as YYYY-MM-DD. It should cover check 1 <= DD <= 31 and 1 <= MM <= 12 for each mm check 1 <=DD<= {28,30,31} (depending) for someYYYY and MM== 02 check 1 <= dd <= 29 I the...

2. Shell Programming and Scripting

Change Date from dd-mmm-yyyy to mm/dd/yyyy

I want to change a date from format dd-mmm-yyyy to mm/dd/yyyy. Is there a way to do this with sed or do you have to write a case statement to convert JAN to 01? Thanks

3. Shell Programming and Scripting

converting the date field from dd/mm/yyyy to yyyy/mm/dd

How to convert the date field from dd/mm/yyyy to yyyy/mm/dd in unix my script will generate text file which have two fields one is date and another is name of the server for example this is sample date which I have to sort based on older to newer date the problem is when I found out sort will...

4. Shell Programming and Scripting

change date format from yyyy/mm/dd to dd/mm/yyyy

(Attention: Green PHP newbie !) I have an online inquiry form, delivering a date in the form yyyy/mm/dd to my feedback form. If the content passes several checks, the form sends an e-mail to me. All works fine. I just would like to receive the date in the form dd/mm/yyyy. I tried with some code,...

5. Shell Programming and Scripting

Converting date DD MM YYYY to DD MON YYYY

Hello, I am writing a script that parses different logs and produces one. In the source files, the date is in DD MM YYYY HH24:MI:SS format. In the output, it should be in DD MON YYY HH24:MI:SS (ie 25 Jan 2010 16:10:10) To extract the dates, I am using shell substrings, i.e.: read line ...

6. Shell Programming and Scripting

awk compare column with date format

I have this code to compare columns 1 and 10 between file1 and file 2 and give me all records that match column 1 but dont match column 10 However column 10 is date format mm/dd/yy and awk cant read it and compare ...i tried awk < file1 -F~ '{print $10}' and it gave blank screen Is...

7. Shell Programming and Scripting

Need date in the format [mm dd yyyy hh AM/PM]

could you please help be on the below code .. Requirement is when i pass the parameter(for below 2) i should get current time -2 hours in the format :wall:.. cur_dt=`$ICEBIN/sqsh -S$DSQUERY -U $BATCHID -P $PASSWD -h -C"select getdate()" | sed '2d'` pr_dt="`$ICEBIN/sqsh -S$DSQUERY -U $BATCHID...

8. Shell Programming and Scripting

Date conversion help from dd/mm/yyyy to dd/Mon/yyyy i.e. 28/10/2012 to 28/Oct/2012

Hi I have a problem with Date format in my code. 1st I am trying to convert today's date to yesterday's using YESTERDAY3=`perl -e '@y=localtime(time()-86400); printf "%04d/%02d/%02d",$y+1900,$y+1,$y;$y;'` And once it is done I am trying to using the yesterday date in a grep command to...

9. UNIX for Dummies Questions & Answers

Epoch date to YYYY/MM/DD or MM/DD/YYYY

I've seen a lot of posts on this and have tried the following: echo 1257000000| perl -e '($d,$m,$y)=(localtime(time-86400));$m+=1;$y+=1900;printf "$y/$m/$d\n";' But I am unable to convert a past Epoch date into a format such as YYYY/MM/DD or MM/DD/YYYY. I am using bash and don't know...

10. Shell Programming and Scripting

Date format YYYY/MM/DD to DD/MM/YYYY

I am getting output of YYYY-MM-DD and want to change this to DD/MM/YYYY. When am running the query in 'Todd' to_date(column_name,'DD/MM/YYYY') am getting the required o/p of DD/MM/YYYY, But when am executing the same query(Netezza) in linux server(bash) am getting the output of YYYY-MM-DD file...

LEARN ABOUT DEBIAN

stripchart

STRIPCHART(5)							File Formats Manual						     STRIPCHART(5)

NAME

       stripchart - draws diagrams from data with PHP

SYNOPSIS

       The script is expected to be called as a CGI script but also works from the command line.

DESCRIPTION

       Stripchart  prepares a series of diagrams directly from raw data.  It is handy for web pages that need some graphics without too much over-
       head.

OPTIONS

       -i input FILE
	      name of input data file (mandatory)

       -o output FILE
	      name of output .gif file (default: STDOUT)

       -O output FILE
	      name of output .gif file, also dumps to STDOUT

       -f from TIME
	      stripchart with data starting at TIME (default: 24 hours ago)

       -t to TIME
	      stripchart with data ending at TIME (default: now)

       -r range RANGE
	      stripchart data centered around "from" time the size of RANGE (overrides -t)

       -l last LINES
	      stripchart last number of LINES in data file (overrides -f and -t and -r)

       -T title TITLE
	      title to put on graphic (default: FILE RANGE)

       -x column X
	      time or "x" column (default: 2)

       -y column Y
	      value or "y" column (default: 3)

       -Y column Y'
	      overplot second "y" column (default: none)

       -b baseline VALUE
	      overplot baseline of arbitrary value VALUE

       -B baseline-avg
	      overrides -b, it plots baseline of computed average

       -d dump low VALUE
	      ignore data less than VALUE

       -D dump high VALUE
	      ignore data higher than VALUE

       -v verbose
	      puts verbose runtime output to STDERR

       -L log makes y axis log scale

       -c colors "COLORS"
	      set gnuplot colors for graph/axisnts/data (default: "xffffff x000000 xc0c0c0 x00a000 x0000a0 x2020c0" in	order:	bground,  axisnts,
	      grids, pointcolor1,2,3)

       -C cgi output CGI header to STDOUT if being called as CGI

       -s stats
	      turn extra plot stats on (current, avg, min, max)

       -j julian times
	      time columns is in local julian date (legacy stuff)

       -V version
	      print version number and exit

       -h help
	      display this help

NOTES

	 * TIME either unix date, julian date, or civil date in the form:
	     YYYY:MM:DD:HH:MM (year, month, day, hour, minute)
	   If you enter something with colons, it assumes it is civil date
	   If you have a decimal point, it assumes it is julian date
	   If it is an integer, it assumes it is unix date (epoch seconds)
	   If it is a negative number, it is in decimal days from current time
	     (i.e. -2.5 = two and a half days ago)
	   * All times on command line are assumed to be "local" times
	   * All times in the data file must be in unix date (epoch seconds)
	 * RANGE is given in decimal days (i.e. 1.25 = 1 day, 6 hours)
	 * if LINES == 0, (i.e. -l 0) then the whole data file is read in
	 * columns (given with -x, -y, -Y flags) start at 1
	 * titles given with -T can contain the following key words which will
	   be converted:
	     FILE - basename of input file
	     RANGE - pretty civil date range (in local time zone)
	   the default title is: FILE RANGE

AUTHORS

       Matt Lebofsky

     2.21							   November 2002						     STRIPCHART(5)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Date Vadidation in YYYY-MM-DD

Discussion started by: itsmehihihi

2. Shell Programming and Scripting

Change Date from dd-mmm-yyyy to mm/dd/yyyy

Discussion started by: stringzz

3. Shell Programming and Scripting

converting the date field from dd/mm/yyyy to yyyy/mm/dd

Discussion started by: pareshan

4. Shell Programming and Scripting

change date format from yyyy/mm/dd to dd/mm/yyyy

Discussion started by: keyboarder