Sponsored Content
Top Forums Shell Programming and Scripting How to replace actual generated date with sysdate? Post 302773483 by jediwannabe on Thursday 28th of February 2013 04:03:41 AM
Old 02-28-2013
How to replace actual generated date with sysdate?

Hi,

currently I've a file with the following content:

Code:
insert into CD_CARD_TYP (code, description, last_update_by, last_update_date)
values ('024', '024', 2, to_date('29-03-2008 05:16:09', 'dd-mm-yyyy hh24:mi:ss'));
insert into CD_CARD_TYP (code, description, last_update_by, last_update_date)
values ('032', '032', 2, to_date('24-04-2008 05:17:30', 'dd-mm-yyyy hh24:mi:ss'));
insert into CD_CARD_TYP (code, description, last_update_by, last_update_date)
values ('034', '034', 2, to_date('24-04-2008 05:17:30', 'dd-mm-yyyy hh24:mi:ss'));

I need to replace the date with SYSDATE, i.e.


Code:
insert into CD_CARD_TYP (code, description, last_update_by, last_update_date)
values ('024', '024', 2, sysdate);
insert into CD_CARD_TYP (code, description, last_update_by, last_update_date)
values ('032', '032', 2, sysdate);
insert into CD_CARD_TYP (code, description, last_update_by, last_update_date)
values ('034', '034', 2, sysdate);

how do I change the above?

thanks a lot!
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to FTP fiels according to generated date

Hi, I need to get some files from a server via ftp. normaly I use following scrip, it is worrking fine. cd dir_name ftp -v -n "10.76.170.17" << cmd user "rbi" "rbi" cd recordreceive prompt... (0 Replies)
Discussion started by: maheshsri
0 Replies

2. Shell Programming and Scripting

Need a script to Append date to generated .txt file

Hi, Can anyone plz share their experience with - Building shell script to append the file with date in following format- Filename_MMDDYYYY.txt Thanks in advance (2 Replies)
Discussion started by: prince_of_focus
2 Replies

3. Shell Programming and Scripting

Open the file and replace the variable with actual value

Hi, i have a sql file named sample.sql. The query is given below. select count(*) from $TABLE_NAME In the main script, i am sourcing this sql. I need to replace the $TABLE_NAME with actual value, before running the query. How can i achieve that? The logic i tried is given below:... (3 Replies)
Discussion started by: bharathappriyan
3 Replies

4. Shell Programming and Scripting

Need help in Shell Script comparing todays date with Yesterday date from Sysdate

Hi, I want to compare today's date(DDMMYYYY) with yesterday(DDMMYYYY) from system date,if (today month = yesterday month) then execute alter query else do nothing. The above requirement i want in Shell script(KSH)... Can any one please help me? Double post, continued here. (0 Replies)
Discussion started by: kumarmsk1331
0 Replies

5. Shell Programming and Scripting

Replace a pattern in a file with a generated number using sed or awk

my file has thousands of line but let me show what i want to achieve... here is one line from that file cat fileName.txt (2,'','user3002,user3003','USER_DATA_SINGLE',1,0,0,'BACKUP',2,NULL,0,450,NULL,NULL,'','2011-05-10... (13 Replies)
Discussion started by: vivek d r
13 Replies

6. UNIX for Advanced & Expert Users

Script to rename file that was generated today and which starts with date

hello, can someone please suggest a script to rename a file that was generated today and filename that being generated daily starts with date, its a xml file. here is example. # find . -type f -mtime -1 ./20130529_4995733057260357019.xml # this finename should be renamed to this format.... (6 Replies)
Discussion started by: bobby320
6 Replies

7. HP-UX

Actual date minus six months (HP UX)

Hi there, is it possible to get the actual date minux six months with just a simple command? It's easy with Linux but on HP Unix (for me) impossible ;) Best wishes (3 Replies)
Discussion started by: System
3 Replies

8. Shell Programming and Scripting

Pass system date and sysdate-7 in script through crontab

Hi , I have to schedule one job in crontab, but with two parameters. 1. Sysdate in YYYYMMDD format 2. Sysdate - 7 in YYYYMMDD format Please suggest how to do that. Thanks in advance. (1 Reply)
Discussion started by: Anupam_Halder
1 Replies

9. UNIX for Beginners Questions & Answers

UNIX script to replace old date with current date dynamically in multiple files present in a folder

I am trying to work on a script where it is a *(star) delimited file has a multiple lines starts with RTG and 3rd column=TD8 I want to substring the date part and I want to replace with currentdate minus 15 days. Here is an example. iam using AIX server $ cat temp.txt RTG*888*TD8*20180201~... (1 Reply)
Discussion started by: Shankar455
1 Replies

10. UNIX for Beginners Questions & Answers

How to replace a parameter(variable) date value inside a text files daily with current date?

Hello All, we what we call a parameter file (.txt) where my application read dynamic values when the job is triggered, one of such values are below: abc.txt ------------------ line1 line2 line3 $$EDWS_DATE_INSERT=08-27-2019 line4 $$EDWS_PREV_DATE_INSERT=08-26-2019 I am trying to... (1 Reply)
Discussion started by: pradeepp
1 Replies
SbVec3fList(3)							       Coin							    SbVec3fList(3)

NAME
SbVec3fList - The SbVec3fList class is a container for arrays of SbVec3f pointers. Note that upon using the equality and inequality operators, the SbVec3f objects themselves are not compared, only the pointer values. SYNOPSIS
#include <Inventor/lists/SbVec3fList.h> Inherits SbPList. Public Member Functions SbVec3fList (void) ~SbVec3fList () void append (const SbVec3f *item) void insert (const SbVec3f *item, const int insertbefore) SbVec3f * operator[] (const int idx) const Additional Inherited Members Detailed Description The SbVec3fList class is a container for arrays of SbVec3f pointers. Note that upon using the equality and inequality operators, the SbVec3f objects themselves are not compared, only the pointer values. Note also that all calls to append() and insert() will cause the list to allocate a new SbVec3f object. These objects are freed when the list is destructed. See also: SbList Constructor &; Destructor Documentation SbVec3fList::SbVec3fList (void) [inline] Default constructor. SbVec3fList::~SbVec3fList () Destructor. Member Function Documentation void SbVec3fList::append (const SbVec3f *item) [inline] Overridden from parent to allocate a new SbVec3f instance when called. See also: SbPList::append() void SbVec3fList::insert (const SbVec3f *item, const intinsertbefore) [inline] Overridden from parent to allocate a new SbVec3f instance when called. See also: SbPList::insert() SbVec3f * SbVec3fList::operator[] (const intidx) const [inline] Overridden from parent to return an SbVec3f. Reimplemented from SbPList. Author Generated automatically by Doxygen for Coin from the source code. Version 3.1.3 Wed May 23 2012 SbVec3fList(3)
All times are GMT -4. The time now is 05:43 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy