formating date


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting formating date
Prev   Next
# 1  
Old 01-03-2007
formating date

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..
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

File formating

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

2. UNIX for Beginners Questions & Answers

File formating help

Hi all, I am having the file below I need that as below Thanks, Arun (12 Replies)
Discussion started by: arunkumar_mca
12 Replies

3. Shell Programming and Scripting

Formating questions

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)
Discussion started by: srikanth38
7 Replies

4. Emergency UNIX and Linux Support

Question on time and date formating..

can anyone one help me....to make date and time format...to following format for my file DATE TIME DD- MON- YEAR 24 Hours I have a need of format like this 12-Jan-2012 in one column, then time in 24 Hours in another column....please help...me... ... (4 Replies)
Discussion started by: nex_asp
4 Replies

5. UNIX for Dummies Questions & Answers

Help with formating when using mailx

Hi I am a newbie here. I tried searching for the solution but I guess I either didn't find it or there hasn't been one posted. my problem is I spooled the results of a query into a .txt file. When I cat the file the formating looks great. All the columns are aligned. However once I mailx the... (2 Replies)
Discussion started by: RB26DETT
2 Replies

6. Shell Programming and Scripting

Formating output

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)
Discussion started by: rocking77
1 Replies

7. Shell Programming and Scripting

Text formating

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)
Discussion started by: jaydeep_sadaria
3 Replies

8. Shell Programming and Scripting

Date Formating in Perl

Hi All, Can anybody tell me why is there a "0" in my output of $date_today ? #!/usr/local/bin/perl $date_today = system "date '+%y%m%d'"; print "$date_today\n"; Output: $ perl test4 080908 0 (3 Replies)
Discussion started by: Raynon
3 Replies

9. Shell Programming and Scripting

Output formating

Dear All I am stuck in one problem. Kindly help me. I am taking below mention file as input file and want some op file as mention below. Kindly send me all possible suggestion and query. Thnaks Jaydeep bELOW IS THE INPUT FILE: *** Connected to BSCANGR ***... (1 Reply)
Discussion started by: jaydeep_sadaria
1 Replies

10. UNIX for Dummies Questions & Answers

Formating in Echo?

Hi, In my code: echo " Field1 " " Filed2 " " Filed3 " >> $myfile echo "--------" "------- " "--------">> $myfile echo $value1 $value2 $value3 >> $myfile echo $value1 $value2 $value3 >> $myfile echo $value1 $value2 $value3 >> $myfile My file... (4 Replies)
Discussion started by: redlotus72
4 Replies
Login or Register to Ask a Question
SWISS::Stars::EV(3pm)					User Contributed Perl Documentation				     SWISS::Stars::EV(3pm)

   new
   fromText
   toText
   sort
   addEvidence($category, $type, $initials, $attributes [, $date])
	Title:	  addEvidence

	Usage:	  $evidenceTag = $entry->Stars->EV->addEvidence($category,
								$type,
								$initials,
								$attributes
								[, $date])

	Function: adds the evidence to the EV block if it does not yet exist
		  or returns the correct evidence tag if the evidence already exists,
		  possibly with a different date.

	Args:	 $category: the evidence category. Currently one of 'A', 'C', 'I','P'.
		 $type: the evidence type
		 $initials: The initals of the person doing the update.
			    For programs this should be '-'.
		 $attributes: the attributes of the evidence
		 $date: optional. If present, it must be in standard SWISS-PROT
			date format. If not present the current date will be used.

	Returns: The correct evidence tag.

   updateEvidence($category, $type, $initials, $attributes [, $date])
	Title:	  updateEvidence

	Usage:	  $evidenceTag = $entry->Stars->EV->updateEvidence($category,
								   $type,
								   $initials,
								   $attributes
								   [, $date])

	Function: updates the evidence to the EV block to $date or inserts it
		  if it does not yet exist.

	Args:	 $category: the evidence category. Currently one of 'A', 'C', 'I','P'.
		 $type: the evidence type
		 $initials: The initals of the person doing the update.
			    For programs this should be '-'.
		 $attributes: the attributes of the evidence
		 $date: optional. If present, it must be in standard SWISS-PROT
			date format. If not present the current date will be used.

	Returns: The correct evidence tag.

Name
       SWISS::Stars::EV.pm

Description
       SWISS/Stars/EV.pm represents the evidence section within an SWISS-PROT + TrEMBL entry. See
       http://www3.ebi.ac.uk/~sp/intern/projects/evidenceTags/index.html

       For a usage example, see evTest.pl in the Swissknife package.

Inherits from SWISS::ListBase.pm
Attributes
       "list" Each element of the list describes one evidence, itself represented as an array.

perl v5.10.1							    2006-01-26						     SWISS::Stars::EV(3pm)