How to convert R$Timestamp in Sql*Plus within a UNIX Shell Script?


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers How to convert R$Timestamp in Sql*Plus within a UNIX Shell Script?
Prev   Next
# 1  
Old 07-03-2013
Wrench How to convert R$Timestamp in Sql*Plus within a UNIX Shell Script?

I need to compare a R$Timestamp field sql within a Unix Shell Script.
In straight SQL the following code works fine:

Table Name: LL_UNIT_TRANSACTION UT
Field: R$Timestamp

Where TRUNC(UT.R$Timestamp) >= TRUNC(SYSDATE -7)


the following returns no data within the Unix Shell Script
AND TRUNC(DATE '1970-01-01' + UT.TIMESTAMP/86400) >= TRUNC(SYSDATE -7)
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Convert date in dd mm yyyy format to UNIX timestamp

Hello All, I have a date in DD/MM/YYYY format. I am trying to convert this into unix timestamp. I have tried following: date -d $mydate +%s where mydate = 23/12/2016 00:00:00 I am getting following error: date: extra operand `+%s' Try `date --help' for more information. ... (1 Reply)
Discussion started by: angshuman
1 Replies

2. Shell Programming and Scripting

AIX : Need to convert UNIX Timestamp to normal timestamp

Hello , I am working on AIX. I have to convert Unix timestamp to normal timestamp. Below is the file. The Unix timestamp will always be preceded by EFFECTIVE_TIME as first field as shown and there could be multiple EFFECTIVE_TIME in the file : 3.txt Contents of... (6 Replies)
Discussion started by: rahul2662
6 Replies

3. Shell Programming and Scripting

Convert UNIX timestamp to readable format in the file

Hello I have a file : file1.txt with the below contents : 237176 test1 test2 1442149024 237138 test3 test4 1442121300 237171 test5 test7 1442112823 237145 test9 test10 1442109600 In the above file fourth field represents the timestamp in Unix format. I found a command which converts... (6 Replies)
Discussion started by: rahul2662
6 Replies

4. Shell Programming and Scripting

How to pass Oracle sql script as argument to UNIX shell script?

Hi all, $ echo $SHELL /bin/bash Requirement - How to pass oracle sql script as argument to unix shell script? $ ./output.sh users.sql Below are the shell scripts and the oracle sql file in the same folder. Shell Script $ cat output.sh #!/bin/bash .... (7 Replies)
Discussion started by: a1_win
7 Replies

5. Shell Programming and Scripting

How can i run sql queries from UNIX shell script and retrieve data into text docs of UNIX?

Please share the doc asap as very urgently required. (1 Reply)
Discussion started by: 24ajay
1 Replies

6. Shell Programming and Scripting

Convert the SQL Query in Shell Script

Hi All, I have a query with output below select 'create synonym "'||TABLE_NAME||'" for '||Table_owner||'."'||table_name||'"'||chr(59) from user_synonyms; ================== create synonym "RV_SBC_SIG" for WFCONTROLLER_TE."RV_SBC_SIG"; create synonym "AQM_TASK" for AWQM_TE."AQM_TASK";... (2 Replies)
Discussion started by: pvmanikandan
2 Replies

7. AIX

convert a specific date to a unix timestamp

hello, i have an AIX5.3 machine and i am writing a script to display some processes. inside the script i want to get the time that the process starts and convert it to a unix timestamp. is there a command that i can use to do that? i search the web but all i found is long scripts and it does... (4 Replies)
Discussion started by: omonoiatis9
4 Replies

8. AIX

Convert unix timestamp to year month day format ?

Hello, How do I convert unix timestamp value to 'normal' date format - to get year month and day values ? Looks like it's easy to do using GNU date (linux systems). But how do I do tthis on AIX ? I don't want to write C program, any ways to do that using unix shells ? thanks (1 Reply)
Discussion started by: vilius
1 Replies

9. Shell Programming and Scripting

To convert a date(in string format) to unix timestamp

Hi All, I have a string like below. "Mar 31 2009" . I want to convert this to unix time . Also please let me know how to find the unix time for the above string minus one day. For Eg. if i have string "Mar 31 2009" i want to find the unix time stamp of "Mar 30 2009". Thanks in advance,... (11 Replies)
Discussion started by: girish.raos
11 Replies

10. Shell Programming and Scripting

Convert Unix Timestame to real timestamp

Hello, Did anyone know how to use script (e.g. perl) to conver Unix Timestame to real timestame in GMT+8 ? 1245900787 file:/tmp/a/Test/.txt.swp has created 1245900988 file:/tmp/a/Test/.txt.swp has changed Thu, 25 Jun 2009 11:33:07 GMT+8 file:/tmp/a/Test/.txt.swp has created Thu, 25 Jun... (4 Replies)
Discussion started by: happyday
4 Replies
Login or Register to Ask a Question
Scheduler Implementation API(3) 			 globus scheduler event generator			   Scheduler Implementation API(3)

NAME
Scheduler Implementation API - Enumerations enum globus_scheduler_event_generator_error_t { GLOBUS_SEG_ERROR_TYPE_NULL = 1024, GLOBUS_SEG_ERROR_TYPE_ALREADY_SET, GLOBUS_SEG_ERROR_TYPE_INVALID_MODULE, GLOBUS_SEG_ERROR_TYPE_INVALID_FORMAT, GLOBUS_SEG_ERROR_TYPE_OUT_OF_MEMORY, GLOBUS_SEG_ERROR_TYPE_LOADING_MODULE } Functions globus_result_t globus_scheduler_event (const char *format,...) globus_result_t globus_scheduler_event_pending (time_t timestamp, const char *jobid) globus_result_t globus_scheduler_event_active (time_t timestamp, const char *jobid) globus_result_t globus_scheduler_event_failed (time_t timestamp, const char *jobid, int failure_code) globus_result_t globus_scheduler_event_done (time_t timestamp, const char *jobid, int exit_code) globus_result_t globus_scheduler_event_generator_get_timestamp (time_t *timestamp) Detailed Description Scheduler-specific SEG module implementations use this API to issue events to the Job State Monitor. Events occur whenever a job is placed in the scheduler's queue (PENDING), begins execution (ACTIVE), terminates successfully (DONE), or ends abnormally (FAILED). A SEG module should register an event with the Globus event driver (most likely using either the Globus Callback or Globus XIO interfaces) in its activation function and then return. All events should be triggered from callbacks. When the SEG detects that it should terminate, it will deactivate the SEG module it started. The SEG module should wait for any outstanding callbacks to subside and before returning from its deactivation function to ensure that all events will be properly dispatched. After deactivation is complete, the SEG will unload the shared module and terminate. Enumeration Type Documentation enum globus_scheduler_event_generator_error_t Error types used by the SEG. Enumerator: GLOBUS_SEG_ERROR_TYPE_NULL NULL Parameter. GLOBUS_SEG_ERROR_TYPE_ALREADY_SET Already called a one-time function. GLOBUS_SEG_ERROR_TYPE_INVALID_MODULE Shared module missing descriptor. GLOBUS_SEG_ERROR_TYPE_INVALID_FORMAT Invalid printf format for SEG protocol message. GLOBUS_SEG_ERROR_TYPE_OUT_OF_MEMORY Out of memory. GLOBUS_SEG_ERROR_TYPE_LOADING_MODULE Unable to load scheduler module. Function Documentation globus_result_t globus_scheduler_event (const char *format, ...) Send an arbitrary SEG notification. Parameters: format Printf-style format of the SEG notification message ... Varargs which will be interpreted as per format. Return values: GLOBUS_SUCCESS Scheduler message sent or queued. GLOBUS_SEG_ERROR_NULL Null format. GLOBUS_SEG_ERROR_INVALID_FORMAT Unable to determine length of formatted string. globus_result_t globus_scheduler_event_pending (time_ttimestamp, const char *jobid) Send a job pending event to the JobSchedulerMonitor implementation. Parameters: timestamp Timestamp to use for the event. If set to 0, the time which this function was called is used. jobid String indicating the scheduler-specific name of the job. Return values: GLOBUS_SUCCESS Scheduler message sent or queued. GLOBUS_SEG_ERROR_NULL Null jobid. GLOBUS_SEG_ERROR_INVALID_FORMAT Unable to determine length of formatted string. globus_result_t globus_scheduler_event_active (time_ttimestamp, const char *jobid) Send a job active event to the JobSchedulerMonitor implementation. Parameters: timestamp Timestamp to use for the event. If set to 0, the time which this function was called is used. jobid String indicating the scheduler-specific name of the job. Return values: GLOBUS_SUCCESS Scheduler message sent or queued. GLOBUS_SEG_ERROR_NULL Null jobid. GLOBUS_SEG_ERROR_INVALID_FORMAT Unable to determine length of formatted string. globus_result_t globus_scheduler_event_failed (time_ttimestamp, const char *jobid, intfailure_code) Send a job failed event to the JobSchedulerMonitor implementation. Parameters: timestamp Timestamp to use for the event. If set to 0, the time which this function was called is used. jobid String indicating the scheduler-specific name of the job. failure_code Failure code of the process if known. Return values: GLOBUS_SUCCESS Scheduler message sent or queued. GLOBUS_SEG_ERROR_NULL Null jobid. GLOBUS_SEG_ERROR_INVALID_FORMAT Unable to determine length of formatted string. globus_result_t globus_scheduler_event_done (time_ttimestamp, const char *jobid, intexit_code) Send a job done event to the JobSchedulerMonitor implementation. Parameters: timestamp Timestamp to use for the event. If set to 0, the time which this function was called is used. jobid String indicating the scheduler-specific name of the job. exit_code Exit code of the process if known. Return values: GLOBUS_SUCCESS Scheduler message sent or queued. GLOBUS_SEG_ERROR_NULL Null jobid. GLOBUS_SEG_ERROR_INVALID_FORMAT Unable to determine length of formatted string. globus_result_t globus_scheduler_event_generator_get_timestamp (time_t *timestamp) Get the timestamp for the earliest event an SEG module should send. Parameters: timestamp Pointer to a time_t which will be set to the timestamp passed to the SEG executable. The module should not send any events which occur prior to this timestamp. Return values: GLOBUS_SEG_ERROR_NULL Null timestamp. GLOBUS_SUCCESS Timestamp value updated. If the timestamp was not set on the SEG command-line, then the value pointed to by timestamp will be set to 0. Author Generated automatically by Doxygen for globus scheduler event generator from the source code. Version 4.6 Mon Apr 30 2012 Scheduler Implementation API(3)