TeraData Sql to add months in timestamp Post: 302895754

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

how to add a timestamp to a filename?

whats going on guys. below is a script i made and am just curious if there is a "time stamp" command. so i can set the timestamp in a filename. #! /bin/ksh # # This scripts takes a list of files in the INDIR variable and compairs it to a list of files that are open in the same directory....

2. Shell Programming and Scripting

add timestamp to filename

Does anyone know how to add a timestamp to a file's name extension in a shell script? Please help..

3. Programming

Unix - teradata

I am trying execute a sql file from the script and the sql file has the following code snippet, which throws out the error given below FOR C_FINELINE_LP AS CURSOR C_SLS FOR SELECT * FROM WM_UTIL.FLT_DEP WHERE LOAD_IND = 'N' DO ..... ..... .... END FOR; FOR C_FLTSLS_STR_LP AS...

4. UNIX for Dummies Questions & Answers

Append file with grep output but add timestamp?

I've setup a cron job that greps a file every five minutes and then writes (appends) the grep output/result to another file: grep "monkey" zoo.log | tail -1 >> cron-zoo-log Is there any way I can add the date and time (timestamp) to the cron-zoo-log file for each time a new line was added? ...

5. Programming

Connect To Teradata

How do i connect from C program to teradata Database? The C program is being executed from a Unix script, AIX. I am calling a C program from a Unix shell script and the C Program executes some SQLs on Teradata Database.

6. Shell Programming and Scripting

Add timestamp and copy files

Please help me with a command to find all files in directory and copy them into another with a timestamp. I have the code to find and copy the files but unable to add timestamp to the files. Below is the find and copy code which i am using(need to add timestamp) find /root/files -name "*.gz"...

7. UNIX for Dummies Questions & Answers

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

8. Shell Programming and Scripting

To check timestamp in logfile and display lines upto 3 hours before current timestamp

Hi Friends, I have the following logfile. Currently time in india is 07/31/2014 12:33:34 and i have the following content in logfile. I want to display only those entries which contain string 'Exception' within last 3 hours. In this case, it would be the last line only I can get the...

9. Shell Programming and Scripting

Grep lines between last hour timestamp and current timestamp

So basically I have a log file and each line in this log file starts with a timestamp: MON DD HH:MM:SS SEP 15 07:30:01 I need to grep all the lines between last hour timestamp and current timestamp. Then these lines will be moved to a tmp file from which I will grep for particular strings. ...

10. UNIX for Beginners Questions & Answers

Add TimeStamp to cron job and write file name sent

Hello, I have written a cron job to automate the sftp of files using key authentication. I wanted to add a timeStamp and name of file sent to a log file and append each these details to the same file each time files are sent and if possible include whether the files were sent successfully or not....

LEARN ABOUT PHP

time_sleep_until

TIME_SLEEP_UNTIL(3)							 1						       TIME_SLEEP_UNTIL(3)

time_sleep_until - Make the script sleep until the specified time

SYNOPSIS

       bool time_sleep_until (float  $timestamp)

DESCRIPTION

	Makes the script sleep until the specified $timestamp.

PARAMETERS

	      o $timestamp
		- The timestamp when the script should wake.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

CHANGELOG

       +--------+---------------------------------------------------+
       |Version |						    |
       |	|						    |
       |	|		     Description		    |
       |	|						    |
       +--------+---------------------------------------------------+
       | 5.3.0	|						    |
       |	|						    |
       |	|  This  function is now available on Windows plat- |
       |	| forms.					    |
       |	|						    |
       +--------+---------------------------------------------------+
ERRORS
/EXCEPTIONS
	If the specified $timestamp is in the past, this function will generate a E_WARNING.

EXAMPLES

       Example #1

	      A time_sleep_until(3) example

	      <?php

	      //returns false and generates a warning
	      var_dump(time_sleep_until(time()-1));

	      // may only work on faster computers, will sleep up to 0.2 seconds
	      var_dump(time_sleep_until(microtime(true)+0.2));

	      ?>

NOTES

       Note

	       All signals will be delivered after the script wakes up.

SEE ALSO

       sleep(3), usleep(3), time_nanosleep(3), set_time_limit(3).

PHP Documentation Group 												       TIME_SLEEP_UNTIL(3)