Sponsored Content
Full Discussion: formating date
Top Forums Shell Programming and Scripting formating date Post 302101655 by jim mcnamara on Wednesday 3rd of January 2007 04:30:44 PM
Old 01-03-2007
Code:
sql > SELECT                                                                  
   SYSDATE - TO_DATE('2006-12-29 12:57:08','YYYY-MM-DD HH:MI:SS')       
FROM DUAL;                                                              

SYSDATE-TO_DATE('2006-12-2912:57:08','YYYY-MM-DDHH:MI:SS')
----------------------------------------------------------
                                                5.06428241

This User Gave Thanks to jim mcnamara For This Post:
 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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
ROTTER(1)																 ROTTER(1)

NAME
rotter - a recording of transmission / audio logger for JACK SYNOPSIS
rotter [options] <directory> DESCRIPTION
Rotter is a Recording of Transmission / Audio Logger for JACK. It was designed for use by radio stations, who are legally required to keep a recording of all their output. Rotter runs continuously, writing to a new file every hour. Rotter can output files in two different strutures, either all files in a single directory or create a directory structure: flat: /root_directory/YYYY-MM-DD-HH.suffix hierarchy: /root_directory/YYYY/MM/DD/HH/archive.suffix combo: /root_directory/YYYY/MM/DD/HH/YYYY-MM-DD-HH.suffix dailydir: /root_directory/YYYY-MM-DD/YYYY-MM-DD-HH.suffix The advantage of using a folder hierarchy is that you can store related files in the hour's directory. OPTIONS
-a Automatically connect JACK ports to the first two JACK input ports found. -f <format> Select the output format of the log files. See the rotter help screen for a list of supported output format names. -b <bitrate> Select the bitrate (in kbps) of the log file. This parameter is only supported by bitstream formats (MPEG Audio). -c <channels> Set the number of input channels to be logged. This number of JACK ports will be created. Should either 1 or 2. -n <name> Choose the name of the Jack client to register as. -N <filename> Choose a filename prefix for the archive files created (default archive). -d <hours> Specifies the number of hours of audio to keep before it is deleted. Files are deleted at the start of every hour, based on the files modification date. Default is to not delete files. -R <secs> Sets the length (in seconds) of the ringbuffer. This is the buffer between the internal audio grabber and the audio encoder. If you have a slow machine you might want to try increating the size of the buffer. -L <layout> Choose a file layout option for the archive files created. See above for a list. -j By default rotter will automatically try and start jackd if it isn't running. This option disables that feature. -v Enable verbose mode. Display more messages about what rotter is doing. -q Enable quiet mode. Only display error messages. EXAMPLES
rotter -a -f mp3 -d 1000 -b 160 -v /var/achives Start logging audio to hourly files in /var/archives. Rotter will automatically connect itself to the first two JACK output ports it finds and encode to MPEG Layer 3 audio at 128kbps. Each hour it will delete files older than 1000 hours (42 days). Verbose mode means it will display more informational messages. AUTHOR
Written by Nicholas J Humfrey RESOURCES
Web site: http://www.aelius.com/njh/rotter/ COPYING
Copyright (C) 2006-2007 Nicholas J Humfrey. Free use of this software is granted under the terms of the GNU General Public License (GPL). 10/03/2010 ROTTER(1)
All times are GMT -4. The time now is 11:39 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy