10-28-2010
Let me clarify the issue that I am facing..
There is a table
create table MyTable
(
S_No int,
date datetime
)
The data in it is as :
select * from MyTable
1 14/03/2010 00:00:00.000
2 12/04/2010 00:00:00.000
Date is in DD/MM/YYYY format in the table.
But now when I am fetching the same data through perl and writing it in a file with pipe separated values, it is coming up as:
more file.txt:
S_No|date
1|Mar 14 2010 12:00AM
2|Apr 12 2010 12:00AM
The format of date is coming up as different in a file from what we have in table. I want it to be same as that of table.
While investigating, I also got to know that not only in perl, if we do simple isql for sybase and redirect the output to the file, date gets converted to 'Mar 14 2010 12:00AM' irespective of the format it is in the table.
What I am not getting is how unix/shell/perl script is converting the date themselves? and how do I keep it the way it is in table?
Thanks
8 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
My script is here--
#!/usr/bin/perl
no warnings "uninitialized";
use File::Copy;
use File::stat;
use Time::Local;
use IO::Handle;
use DateTime;
use Getopt::Long;
use File::Glob ':glob';
my $Summary;
my $Individual;
my $Diagnostics;
my $All; (3 Replies)
Discussion started by: namishtiwari
3 Replies
2. Programming
Hi All,
This Monday 15th March 2010, i have faced a weired issue with my Perl script execution, this script is scheduled to run at 1 minute past midnight on daily basis ( 00:01 EST ) generally for fetching previous business date , say if it is Monday it should give last Friday date, for Tuesday... (0 Replies)
Discussion started by: ravimishra
0 Replies
3. Shell Programming and Scripting
hi guys,
i have a variable date that stores the current date....now i need to subtract 2 minutes from it...can someone tell me how to do it in perl.... (5 Replies)
Discussion started by: niteesh_!7
5 Replies
4. Programming
Hello Friends,
I have been struck with a perl script for quite some time now. I have a log file which gives a date which is sometimes coming in this format
Script /opt/OV/bin/OpC/agtinstall/inst.sh invoked by root at 02/25/11 15:12:50
or sometimes in this format
Script... (2 Replies)
Discussion started by: achak01
2 Replies
5. Shell Programming and Scripting
Hi All,
Want to get all dates and Julian week number for that date between the start date and end date. How can I achive this using perl?
(To achive above functionality, I was connecting to the database from DB server. Need to execute the same script in application server, since databse... (6 Replies)
Discussion started by: Nagaraja Akkiva
6 Replies
6. Shell Programming and Scripting
Hi All,
what i want to do in perl is i should give the date at run time .Suppose date given is 23/12/2011(mm/dd/yyyy) the perl script shold find week start date, week end date, previous week start date,end date,next week start date, end date. In this case
week start date will be-:12/19/2011... (2 Replies)
Discussion started by: parthmittal2007
2 Replies
7. Shell Programming and Scripting
$beginDate = substr(DateCalc("today", "-7Days"),0,8);
This fetches the date 7 days back
Can I fetch the date before 7 years from todays date in Perl using same syntax
Use code tags, see PM. (3 Replies)
Discussion started by: parthmittal2007
3 Replies
8. Shell Programming and Scripting
my $sysdate = strftime('%Y-%m-%d', localtime );
biDeriveByDate('Table_Str',$sysdate,\@lIndx,\@lResVals)
In a perl script, when I'm trying to pass $sysdate to some external function it's not working since $sysdate is passed as a string mentioned above but my function is expecting a date value... (1 Reply)
Discussion started by: Devesh5683
1 Replies
LEARN ABOUT CENTOS
corelist
CORELIST(1) Perl Programmers Reference Guide CORELIST(1)
NAME
corelist - a commandline frontend to Module::CoreList
DESCRIPTION
See Module::CoreList for one.
SYNOPSIS
corelist -v
corelist [-a|-d] <ModuleName> | /<ModuleRegex>/ [<ModuleVersion>] ...
corelist [-v <PerlVersion>] [ <ModuleName> | /<ModuleRegex>/ ] ...
corelist [-r <PerlVersion>] ...
corelist --diff PerlVersion PerlVersion
OPTIONS
-a lists all versions of the given module (or the matching modules, in case you used a module regexp) in the perls Module::CoreList knows
about.
corelist -a Unicode
Unicode was first released with perl v5.6.2
v5.6.2 3.0.1
v5.8.0 3.2.0
v5.8.1 4.0.0
v5.8.2 4.0.0
v5.8.3 4.0.0
v5.8.4 4.0.1
v5.8.5 4.0.1
v5.8.6 4.0.1
v5.8.7 4.1.0
v5.8.8 4.1.0
v5.8.9 5.1.0
v5.9.0 4.0.0
v5.9.1 4.0.0
v5.9.2 4.0.1
v5.9.3 4.1.0
v5.9.4 4.1.0
v5.9.5 5.0.0
v5.10.0 5.0.0
v5.10.1 5.1.0
v5.11.0 5.1.0
v5.11.1 5.1.0
v5.11.2 5.1.0
v5.11.3 5.2.0
v5.11.4 5.2.0
v5.11.5 5.2.0
v5.12.0 5.2.0
v5.12.1 5.2.0
v5.12.2 5.2.0
v5.12.3 5.2.0
v5.12.4 5.2.0
v5.13.0 5.2.0
v5.13.1 5.2.0
v5.13.2 5.2.0
v5.13.3 5.2.0
v5.13.4 5.2.0
v5.13.5 5.2.0
v5.13.6 5.2.0
v5.13.7 6.0.0
v5.13.8 6.0.0
v5.13.9 6.0.0
v5.13.10 6.0.0
v5.13.11 6.0.0
v5.14.0 6.0.0
v5.14.1 6.0.0
v5.15.0 6.0.0
-d finds the first perl version where a module has been released by date, and not by version number (as is the default).
--diff
Given two versions of perl, this prints a human-readable table of all module changes between the two. The output format may change in
the future, and is meant for humans, not programs. For programs, use the Module::CoreList API.
-? or -help
help! help! help! to see more help, try --man.
-man
all of the help
-v lists all of the perl release versions we got the CoreList for.
If you pass a version argument (value of $], like 5.00503 or 5.008008), you get a list of all the modules and their respective
versions. (If you have the "version" module, you can also use new-style version numbers, like 5.8.8.)
In module filtering context, it can be used as Perl version filter.
-r lists all of the perl releases and when they were released
If you pass a perl version you get the release date for that version only.
As a special case, if you specify the module name "Unicode", you'll get the version number of the Unicode Character Database bundled with
the requested perl versions.
EXAMPLES
$ corelist File::Spec
File::Spec was first released with perl 5.005
$ corelist File::Spec 0.83
File::Spec 0.83 was released with perl 5.007003
$ corelist File::Spec 0.89
File::Spec 0.89 was not in CORE (or so I think)
$ corelist File::Spec::Aliens
File::Spec::Aliens was not in CORE (or so I think)
$ corelist /IPC::Open/
IPC::Open2 was first released with perl 5
IPC::Open3 was first released with perl 5
$ corelist /MANIFEST/i
ExtUtils::Manifest was first released with perl 5.001
$ corelist /Template/
/Template/ has no match in CORE (or so I think)
$ corelist -v 5.8.8 B
B 1.09_01
$ corelist -v 5.8.8 /^B::/
B::Asmdata 1.01
B::Assembler 0.07
B::Bblock 1.02_01
B::Bytecode 1.01_01
B::C 1.04_01
B::CC 1.00_01
B::Concise 0.66
B::Debug 1.02_01
B::Deparse 0.71
B::Disassembler 1.05
B::Lint 1.03
B::O 1.00
B::Showlex 1.02
B::Stackobj 1.00
B::Stash 1.00
B::Terse 1.03_01
B::Xref 1.01
COPYRIGHT
Copyright (c) 2002-2007 by D.H. aka PodMaster
Currently maintained by the perl 5 porters <perl5-porters@perl.org>.
This program is distributed under the same terms as perl itself. See http://perl.org/ or http://cpan.org/ for more info on that.
perl v5.16.3 2014-06-17 CORELIST(1)