Guys
I have a date value like this in a table -> 2006-12-29 12:57:08(data type varchar2(25))
I am trying to subtract this column from sysdate.
I am unable to do that. can u guys suggest me a way to do this.. (2 Replies)
Hi all, I want to start a new topic on this matter
I have this script,
#!perl
use strict;
use warnings;
use Data::Dumper;
open my $log, '>', 'log-external.txt' or die "Could not open log: $!";
print $log "Subnet,Static,DHCP,Unused\n";
open my $dump, '>', 'dump.log' or die... (2 Replies)
Dear all
I had input file as mention below and want op as mention.
Kindly let me knw possible ways.
Regards
Jaydeep
INPUT:
RXOTX-48-1
2A 34
2B 35
RXOTX-499-2
2C 32
RXOTX-4-1
2D 23
OUTPUT: (3 Replies)
Hello Team i have a file with following data (as columns).
I need implement a syntax like below for altering table
ALTER TABLE1 TABLENAME
ADD COLUMN COL1 CHAR(5) NOT NULL WITH DEFAULT
ADD COLUMN COL2 CHAR(5)
..
..
ADD COLUMN COLn CHAR(5) NOT NULL... (1 Reply)
This is a bit off the wall, but I often need to run scripts where there are argument values that contain special characters.
For example,
$ ./process.exe -t M -N -o temp.mol.s -i ../molfiles/N,N\',N\'\'-trimethylbis\(hexamethylene\)triamine.mol && sfile_space_to_tab.sh temp.mol.s temp.s
It... (1 Reply)
Hi,
I have a data as follows in some files, i want to change CHAR(2-20) to VARCHAR(2-20). I should not touch any line with CHAR(1)
Example:
Input:
cur_rev_stage_cd CHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
prev_rev_stage_cd CHAR(5) CHARACTER SET LATIN NOT... (7 Replies)
I need to create a fixed width file based on the column lengths.
lets assume I have six(this may be dynamic) fields each are of different length
column1=6 #size of the column
column2=3
column3=2
column4=3
column5=4
column6=5
I tried below code snippet but it is not working
echo... (4 Replies)
Discussion started by: gvkumar25
4 Replies
LEARN ABOUT DEBIAN
netsds::util::datetime
NetSDS::Util::DateTime(3pm) User Contributed Perl Documentation NetSDS::Util::DateTime(3pm)NAME
NetSDS::Util::DateTime - common date/time processing routines
SYNOPSIS
use NetSDS::Util::DateTime;
print "Current date: " . date_now();
DESCRIPTION
This package provides set of routines for date and time processing.
EXPORTED FUNCTIONS
date_now_array([TIME])
Returns array of date items for given date. If source date is not set current date used.
date_now([TIME])
Return [given] date as string.
2001-12-23 14:39:53
date_now_iso8601([TIME])
Return date as ISO 8601 string.
20011223T14:39:53Z
<http://en.wikipedia.org/wiki/ISO_8601> http://www.w3.org/TR/NOTE-datetime <http://www.w3.org/TR/NOTE-datetime>
date_strip(DATE)
Trim miliseconds from date.
date_date(DATE)
Trim time part from date.
date_time(DATE)
Trim date part from date.
time_from_string($string)
Return parsed date/time structure.
date_from_string($string)
Return date from string representation.
date_inc([INCREMENT, [TIME]])
Return date incremented with given number of seconds.
date_inc_string([INCREMENT, [TIME]])
Return string representation of date incremented with given number of seconds.
EXAMPLES
None yet
BUGS
Unknown yet
SEE ALSO
Date::Parse, Date::Format
TODO
Import stuff from Wono project
AUTHOR
Valentyn Solomko <val@pere.org.ua>
Michael Bochkaryov <misha@rattler.kiev.ua>
perl v5.12.4 2011-08-27 NetSDS::Util::DateTime(3pm)