Sponsored Content
Top Forums UNIX for Advanced & Expert Users Select entries between two dates by converting Unix timestamp in Oracle Database. Post 302083918 by jim mcnamara on Tuesday 8th of August 2006 11:00:41 AM
Old 08-08-2006
Since you are using to_char, FIRSTOCCURRENCE must of of datatype DATE.
So, UNIX has nothing to do with it.

Try
Code:
SELECT COUNT(*) 
FROM 
     REPORTER_STATUS
  WHERE  TRUNC(FIRSTOCCURRENCE) between to_date('08-07-2006','DD-MM-YYYY')
       and to_date('08-08-2006','DD-MM-YYYY');

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

unix script to export data from csv file to oracle database

Hello people, Need favour. The problem I have is that, I need to develop a unix shell script that performs recurring exports of data from a csv file to an oracle database. Basically, the csv file contains just the first name and last name will be dumped to an Unix server. The data from these... (3 Replies)
Discussion started by: vinayagan
3 Replies

2. Programming

converting unix timestamp into readable format using c++

hi everyone, im new here and am in desperate need of help. I want to convert my 32 bit unix time stamp ' 45d732f6' into a readable format (Sat, 17 February 2007 16:53:10 UTC) using c++. I have looked around the interent but i just cant make sense of anything. All examples i can find just... (3 Replies)
Discussion started by: uselessprog
3 Replies

3. Shell Programming and Scripting

How to COnnect to Oracle database from UNIX Box

I am trying to connect to Oracle Databse from UNIX box using sqlplus command. But i get sqplus not found message. $ sqlplus sqlplus: not found I have searched in forums and all are suggesting to set environment varaibles...can somebody tell me what variables to set and how to set.and the... (12 Replies)
Discussion started by: angelarosh
12 Replies

4. Shell Programming and Scripting

How to connect with oracle database using unix...

Hi all I am working in datawarehouse project and use DB2 database . shell scripting is written to connect with DB2 database in my application but i dont know how to connect with oracle databse or other databases.Is there any command in unix to connect any of these datbases? (6 Replies)
Discussion started by: vijays3
6 Replies

5. Shell Programming and Scripting

how to split the row(array) in to fields and store in to oracle database in unix

Hi, the csv file with the delimeter #. A#B#C#D#E#F#G#H 1#2#3#4#5#6#7#8 Z#x#c#V 7#2#8#9 N. I want to read the file line by line and store in rowarray. then the rowarray content should be spilt or made to fields using the delimeter #. i am not sure can we store the fields in to... (3 Replies)
Discussion started by: barani75
3 Replies

6. Shell Programming and Scripting

Select multiple values from an Oracle database and assign it to two dimensional array

hi I have two tables in oracle DB and am using a joining query which will result in the output as follows. i need to assign it to a two dimensional array and use it for my further calculations. the way i tried is as follows. #!/bin/ksh export... (1 Reply)
Discussion started by: aemunathan
1 Replies

7. Shell Programming and Scripting

why do we need UNIX shell script to load data into Oracle database

Hello everyone, I am new to shell scripting/ loading data into a database. I want to load data into Oracle database using SQL loader. Can some one please explain why do we need unix shell script to load the data into the database? Also can someone please explain what has to be in that script?... (5 Replies)
Discussion started by: new_prog
5 Replies

8. Shell Programming and Scripting

How to run a SQL select query in Oracle database through shell script?

I need to run a SQL select query in Oracle database and have to capture the list of retrieved records in shell script. Also i would like to modify the query for certain condition and need to fetch it again. How can i do this? Is there a way to have a persistent connection to oracle database... (9 Replies)
Discussion started by: vel4ever
9 Replies

9. Shell Programming and Scripting

Oracle Database connection from UNIX

Hi I have a question regarding Oracle connection using the below code ${ORACLE_HOME}/bin/sqlplus -s $user/$pwd@$sid <<!EOF 1>> $v_log_dir/$v_job_log.out 2>> $v_log_dir/$v_job_log.err / prompt stored procedure beginning . . . exec xx_interface_pkg.pr_xx_clms_out($datayears,$keepmonths); ... (3 Replies)
Discussion started by: smilingraja
3 Replies

10. Shell Programming and Scripting

Timestamp between two dates

Hi, I want to find out the difference in minutes, and seconds between two dates for a job.Tried searching many ways but none of them worked correctly. eg: Start Time End Time 04/10/2015 02:02:27 04/10/2015 02:02:37 ---- should return 10s 04/10/2015 02:02:27 04/10/2015... (1 Reply)
Discussion started by: rogerben
1 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:11 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy