06-03-2019
Where I ran into real world problems is with free form entry on date (as text) fields. So. The mix provided by the OP was not realistic based on my experience.
I had to correct several hundred million rows of almost unbelievable garbage dates in a transaction table. The data was entered by users in several countries.
Example: "Apr 4". Okay. What year? I had to use the table's unique sequence and search nearby to find temporally close rows until I found a year. So for each
bizarre date problem we ran a separate script with a subsequent validation script. Took several weeks to fix the mess.
Overall the problems got better run times as more neighbors were "fixed" - in this one kind of example problem.
This User Gave Thanks to jim mcnamara For This Post:
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
1) i am trying to print the timeframe of a log file using the start/end date/time being extracted from the file itself. my problem is how to convert the following numeric date format to the one that i prefer:
Start time: 0204161129
End time : 0204171431
into:
Start time: Apr 16 2002... (6 Replies)
Discussion started by: apalex
6 Replies
2. Shell Programming and Scripting
I have a file named "suspected" with series of line like these :
{'protocol': 17, 'service': 'BitTorrent KRPC', 'server': '219.78.120.166', 'client_port': 52044, 'client': '10.64.68.44', 'server_port': 8291, 'time': 1226506312L, 'serverhostname': ''}
{'protocol': 17, 'service': 'BitTorrent... (3 Replies)
Discussion started by: rk4k
3 Replies
3. Shell Programming and Scripting
I want to append current date and time to a file name like filename_090920091210. If I use filename_`date +%d%m%Y%T`, the ouput is filename_0909200912:10:33.
How to format this as filename_090920091210.
Please let me know.
Thanks in advance. (3 Replies)
Discussion started by: srimenon09
3 Replies
4. Shell Programming and Scripting
Frens,
I have a logfile which has got manier things in it and somewer in that file i have a date in mm/dd/yyyy hh:mm format....
I just need to get the date and time nothing else....
i have searched in this forum for it but got only date in mm-dd-yyyy format..
but i need to search for... (10 Replies)
Discussion started by: smarty86
10 Replies
5. Shell Programming and Scripting
This gives:
grep "qprt -o -dp -N 1 -P" printfile.log.1216 |awk '{print $7, $9}' |grep lpc1z
The output like below:
lpc1z /cerner/d_prod/print/ccltemp4235396d030a.dat.tmp.1216075330]
lpc1z /cerner/d_prod/print/ccltemp4235396d036a.dat.tmp.1216075634]
lpc1z... (2 Replies)
Discussion started by: Daniel Gate
2 Replies
6. UNIX for Dummies Questions & Answers
Hello,
I am trying to show today's date and time in a better format than ‘date' (Using positional parameters). I found a command mktime and am wondering if this is the best command to use or will this also show me the time elapse since 1/30/70? Any help would be greatly appreciated, Thanks... (3 Replies)
Discussion started by: citizencro
3 Replies
7. Shell Programming and Scripting
Hello All,
I have a requirement to convert a 12 hour format to 24 hour time format and the sample input /out put is below
Input Time format : Nov 2 2011 12:16AM
Out Put Format : Nov 2 2011 0:16
Input : Nov 2 2011 4:16PM
Out Put: Nov 2 2011 16:16
I have done this using a... (6 Replies)
Discussion started by: jambesh
6 Replies
8. HP-UX
Hello,
I have date format as shown in red color below
Fri, Sep 12, 2012 08:38:05 PM
Can anyone help me with command to change this format to yyyy-mm-dd and HH:MM:SS
Note: Time should be in 24 hours format
I really appreciate your help!!
Thanks,
Elavarasan (4 Replies)
Discussion started by: Elavarasan
4 Replies
9. Shell Programming and Scripting
Hi, I am extracting a date string from the source file like this :
06/05/2014 16:04:00
I want to change it to 05-JUN-14 04.05.00.000000000 PM
I basically store the date in a variable. I got solutions to change date in dd-mmm-yyyy format using tr but I guess it works only with the "date"... (8 Replies)
Discussion started by: Varshha
8 Replies
10. Shell Programming and Scripting
How can I validate if time (HH:MM:SS) argument is valid? I got this from web but I can't modify it to exit the script if the time argument is invalid.
echo $1 | awk -F ':' '{ print ($1 <= 23 && $2 <= 59 && $3 <= 59) ? "good" : "bad" }'
ex:
./script.ksh 12:34:21 = okay
./script.ksh... (10 Replies)
Discussion started by: erin00
10 Replies
LEARN ABOUT DEBIAN
calendar::simple
Calendar::Simple(3pm) User Contributed Perl Documentation Calendar::Simple(3pm)
NAME
Calendar::Simple - Perl extension to create simple calendars
SYNOPSIS
use Calendar::Simple;
my @curr = calendar; # get current month
my @this_sept = calendar(9); # get 9th month of current year
my @sept_2002 = calendar(9, 2002); # get 9th month of 2002
my @monday = calendar(9, 2002, 1); # get 9th month of 2002,
# weeks start on Monday
my @span = date_span(mon => 10, # returns span of dates
year => 2006,
begin => 15,
end => 28);
DESCRIPTION
A very simple module that exports one function called "calendar".
calendar
This function returns a data structure representing the dates in a month. The data structure returned is an array of array references. The
first level array represents the weeks in the month. The second level array contains the actual days. By default, each week starts on a
Sunday and the value in the array is the date of that day. Any days at the beginning of the first week or the end of the last week that are
from the previous or next month have the value "undef".
If the month or year parameters are omitted then the current month or year are assumed.
A third, optional parameter, start_day, allows you to set the day each week starts with, with the same values as localtime sets for wday
(namely, 0 for Sunday, 1 for Monday and so on).
date_span
This function returns a cur-down version of a month data structure which begins and ends on dates other than the first and last dates of
the month. Any weeks that fall completely outside of the date range are removed from the structure and any days within the remaining weeks
that fall outside of the date range are set to "undef".
As there are a number of parameters to this function, they are passed using a named parameter interface. The parameters are as follows:
year
The required year. Defaults to the current year if omitted.
mon The required month. Defaults to the current month if omitted.
begin
The first day of the required span. Defaults to the first if omitted.
end The last day of the required span. Defaults to the last day of the month if omitted.
start_day
Indicates the day of the week that each week starts with. This takes the same values as the optional third parameter to "calendar". The
default is 0 (for Sunday).
This function isn't exported by default, so in order to use it in your program you need to use the module like this:
use Calendar::Simple 'date_span';
EXAMPLE
A simple "cal" replacement would therefore look like this:
#!/usr/bin/perl -w
use strict;
use Calendar::Simple;
my @months = qw(January February March April May June July August
September October November December);
my $mon = shift || (localtime)[4] + 1;
my $yr = shift || (localtime)[5] + 1900;
my @month = calendar($mon, $yr);
print "
$months[$mon -1] $yr
";
print "Su Mo Tu We Th Fr Sa
";
foreach (@month) {
print map { $_ ? sprintf "%2d ", $_ : ' ' } @$_;
print "
";
}
A version of this example, called "pcal", is installed when you install this module.
Date Range
This module will make use of DateTime.pm if it is installed. By using DateTime.pm it can use any date that DateTime can represent. If
DateTime is not installed it uses Perl's built-in date handling and therefore can't deal with dates before 1970 and it will also have
problems with dates after 2038 on a 32-bit machine.
EXPORT
"calendar"
AUTHOR
Dave Cross <dave@mag-sol.com>
ACKNOWLEDGEMENTS
With thanks to Paul Mison <cpan@husk.org> for the start day patch.
COPYRIGHT
Copyright (C) 2002-2008, Magnum Solutions Ltd. All Rights Reserved.
LICENSE
This script is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
SEE ALSO
perl, localtime, DateTime
perl v5.10.1 2010-04-02 Calendar::Simple(3pm)