Query - date command


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Query - date command
Prev   Next
# 1  
Old 03-25-2013
Query - date command

Hi,

I am trying to capture the total run time of a script which contains SQL's by providing date command in top & bottom, it displaying both the times same in top & bottom.However the time in the sql connection is different.Please help.

OS - LINUX
Shell - ksh


Code:
printf "Script Started at $date" >> $LOGFILE
sqlplus userid/pwd test1.sql
.
.
.
sqlplus userid/pwd testn.sql
printf "Script Ended at $date" >> $LOGFILE

 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. HP-UX

awk command in hp UNIX subtract 30 days automatically from current date without date illegal option

current date command runs well awk -v t="$(date +%Y-%m-%d)" -F "'" '$1 < t' myname.dat subtract 30 days fails awk -v t="$(date --date="-30days" +%Y-%m-%d)" -F "'" '$1 < t' myname.dat awk command in hp unix subtract 30 days automatically from current date without date illegal option error... (20 Replies)
Discussion started by: kmarcus
20 Replies

2. HP-UX

HP/UX command to pull file name/date based on date

HI, Can anyone tell me how to pull the date and file name separated by a space using the find command or any other command. I want to look through several directories and based on a date timeframe (find -mtime -7), output the file name (without the path) and the date(in format mmddyyyy) to a... (2 Replies)
Discussion started by: lnemitz
2 Replies

3. Shell Programming and Scripting

Find week of the year for given date using date command inside awk

Hi all, Need an urgent help on the below scenario. script: awk -F"," 'BEGIN { #some variable assignment} { #some calculation and put values in array} END { year=#getting it from array and assume this will be 2014 month=#getting it from array and this will be 05 date=#... (7 Replies)
Discussion started by: vijaidhas
7 Replies

4. UNIX for Dummies Questions & Answers

Date Query

I need to generate a report on the first of each month that will show me how many points are going to expire on a particular scheme for the next three months. The points expiry is not an issue what I have an issue with is finding the command to give me the last day of each month for the current and... (2 Replies)
Discussion started by: theref
2 Replies

5. Shell Programming and Scripting

how to obtain date and day of the week from `date` command

Hi, does anybody know how to format `date` command correctly to return the day of the week? Thanks -A I work in ksh.... (1 Reply)
Discussion started by: aoussenko
1 Replies

6. Shell Programming and Scripting

Convertion of Date Format using SQL query in a shell script

When I write Select date_field from TableA fetch first row only I am getting the output as 09/25/2009. I want to get the output in the below format 2009-09-25 i.e., MM-DD-YYYY. Please help (7 Replies)
Discussion started by: dinesh1985
7 Replies

7. Shell Programming and Scripting

Query regarding date field in shell script

Hi, I wrote a simple shell script which accepts the input value yearmonth in the format YYYYMM and displays the date as YYYY-MM-DD.Day will be 01 always.Please find the code below #!/bin/ksh export yearmonth_date=$1 print_usage() { echo "usage: ${0##*/} <yearmonth_date> \n" \ ... (1 Reply)
Discussion started by: kavithakuttyk
1 Replies

8. Shell Programming and Scripting

Date & NUmber Validation Query

Hi Do you have any pointers how to validate numbers (not to contain alphabets and special characters) and date(MM/DD/YYYY) format. I used following regular expression to validate integer, which is not working in the default shell: nodigits="$(echo $testvalue | sed 's/]//g')" ... (4 Replies)
Discussion started by: alok_jax
4 Replies

9. UNIX for Dummies Questions & Answers

Date change related query

Good day folks, This is my first post on this board and I thank you in advance for helping me with this issue. Any idea how I can synchronize server time with another timeserver but have my server lag behind by 2 seconds? Meaning...I need a simple unix script that I can run as crone that... (2 Replies)
Discussion started by: franklo
2 Replies

10. UNIX for Advanced & Expert Users

Unix Date query

Hi there, I am trying to do the following in Unix (Solaris 2.7): 1...Find the actual date 7 days ago in format (dd-mmm-yyyy) and with the weekday prefably, 2...Find the date 5 days after the above in the same format. How can I do this in Unix instead of accessing our Oracle database and... (5 Replies)
Discussion started by: csong2
5 Replies
Login or Register to Ask a Question
WMTIME(1)						      General Commands Manual							 WMTIME(1)

NAME
wmtime - Window Maker dockapp that displays the time and date SYNOPSIS
wmtime [ OPTION ] DESCRIPTION
WMTime displays the time and date and gives you some nice additional features too. It is intended for docking in Window Maker. It currently provides: o the time and date; o a realtime morphing interface (analog <> digital mode); o auto-scaled and anti-aliased hands; o localization, displaying the day and date in various languages; o three user-defined commands to launch. OPTIONS
-d, -digital Display the digital clock on startup, instead of the analog clock. -display display This option specifies the X server to contact; see X(7x). -geometry geometry This option specifies the preferred position of clock; see X(7x). -n, -noseconds Disables the second hand. -h Show help information. -v Print the version number. USAGE
The WMTime window is separated into top and bottom sections. The top section contains a clock and the bottom section contains the date. The clock can be toggled between analog and digital modes. To do this, click in the bottom section of the window. WMTime can also be used to launch programs. You may click either left, middle, or right mouse buttons in the top section of the window. The pre-configured program will be launched according to the mouse button clicked. (see CONFIGURATION FILE below.) In order to move WMTime, drag on the outer edges. These are not sensitive to mouse clicks. DOCKING IN WINDOW MANAGERS
Window Maker Window Maker users should drag and drop the WMTime window on the Dock. Then, right-click on the border of the window and select "Settings...". Check "Start when Window Maker is started". AfterStep AfterStep users should put the following in their $HOME/.steprc Wharf wmtime - MaxSwallow "wmtime" wmtime & Other window managers WMTime runs nicely as a 64x64 shaped icon on your desktop. CONFIGURATION FILE
WMTime can launch three user-defined commands, triggered by left, middle and right mouse button clicks. You can define the commands to launch in $HOME/.wmtimerc left: xterm middle: xload right: xcalc If WMTime detects a $HOME/.wmtimerc file, it will launch the appropriate command when you click on the clock. The system administrator can define default commands in /etc/wmtimerc. The administrator may also choose to "fix" particular commands, making it impossible for users to change. These commands can be defined in /etc/wmtimerc.fixed, although this isn't a nice thing to do. FILES
/etc/wmtimerc $HOME/.wmtimerc /etc/wmtimerc.fixed AUTHORS
WMTime was written by Martijn Pieterse and Antoine Nulle. This manual page was written by Simon Law <sfllaw@debian.org> for the Debian system (but may be used by others). It is based on the docu- mentation provided by the original program. This manual is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. WMTIME 1.0b2 May 1998 WMTIME(1)