Data is availble in .txt files, using .txt files to load data into database.
when data loading into Database, we are cnverting date and time formats using Datbase functions.
It 's taking long time to convert date and time to Datatbase default fomat.
so we are planing to convert the data in file level then load data into Database.
Have space between Day and year.
Data in files:
File1 :
Code:
Richard|Standard | Not asigned| Insured | New York | Jan 01 2015 11:00:00 PM
John | Not Standard | asigned| Insured | New York | Jan 01 2015 11:00:00 PM
James | No| Assigned| No| New york | Jan 01 2015 11:00:00 PM
File 2":
Code:
Richard|Standard |Nov 01 2014 10:00:00 PM| Not asigned| Insured | New York | Jan 01 2015 11:00:00 PM
John | Not Standard | Jan 05 2014 11:00:00 PM| asigned| Insured | New York | Jan 01 2015 11:00:00 PM
James | No|Sep 01 2014 10:00:00 AM| Assigned| No| New york | Jan 01 2015 11:00:00 PM
Moderator's Comments:
Please wrap all code, files, input & output/errors in CODE tags.
It makes them easier to read and preserves multiple spaces, wich can be critical for fixed width data.
Last edited by rbatte1; 05-11-2015 at 10:35 AM..
Reason: Added CODE tags and moderator comment.
I have the following perl one-liner to get yesterday's date, but I would like it in the form of dd-MMM-yy (for example: 01-JAN-12). Can someone alter the below code so I get the format I want? Also, could someone also give me a line for dd-Mmm-yy (for example 01-Jan-12)?
Code:
YEST=`perl -w... (3 Replies)
How to convert date format such as 7/18/2015 to the number of month from requesting date 'date' in sh scripting ?
Let say I have output in my log.txt -> 7/18/2015. How I convert it to the full number of month starting from 'date' till 7/18/2015 in shell scripting ? Thanks in advance. (1 Reply)
I hear the Leap second for 2015 will occur on June 30 at 23:59:60 according to the wild rumours from internet the expected impact ranges from crashing to hanging servers.
Can anybody share their preparations what they have done for solaris servers? are there any patches to install or workaround?... (1 Reply)
Dear friends,
i am having some Problems with a Sco Openserver in a Box (normally on VMWare, importing it on a Virtualbox does the same).
When i boot up the system on xx/09/2015 i got fork failed - too many processes during startup.
The programs which should run on the server, do not run.
I... (67 Replies)
Discussion started by: ChipperEs
67 Replies
LEARN ABOUT SUSE
email::date::format
Email::Date::Format(3) User Contributed Perl Documentation Email::Date::Format(3)NAME
Email::Date::Format - produce RFC 2822 date strings
SYNOPSIS
use Email::Date::Format qw(email_date);
my $header = email_date($date->epoch);
Email::Simple->create(
header => [
Date => $header,
],
body => '...',
);
DESCRIPTION
This module provides a simple means for generating an RFC 2822 compliant datetime string. (In case you care, they're not RFC 822 dates,
because they use a four digit year, which is not allowed in RFC 822.)
FUNCTIONS
email_date
my $date = email_date; # now
my $date = email_date( time - 60*60 ); # one hour ago
"email_date" accepts an epoch value, such as the one returned by "time". It returns a string representing the date and time of the
input, as specified in RFC 2822. If no input value is provided, the current value of "time" is used.
"format_date" is exported only if requested.
email_gmdate
my $date = email_gmdate;
"email_gmdate" is identical to "email_date", but it will return a string indicating the time in Greenwich Mean Time, rather than local
time.
"format_gmdate" is exported only if requested.
PERL EMAIL PROJECT
This module is maintained by the Perl Email Project
<http://emailproject.perl.org/wiki/Email::Date::Format>
AUTHOR
Ricardo SIGNES, <rjbs@cpan.org>.
Adapted from Email::Date, by Casey West.
COPYRIGHT
Copyright (c) 2007, Ricarod SIGNES. This module is free software; you can redistribute it and/or modify it under the same terms as Perl
itself.
perl v5.12.1 2007-12-03 Email::Date::Format(3)
05-11-2015
