Sponsored Content
Full Discussion: Query - date command
Top Forums Shell Programming and Scripting Query - date command Post 302785301 by radoulov on Monday 25th of March 2013 09:37:36 AM
Old 03-25-2013
You could use:
Code:
printf 'Script Started at %s\n' "$( date )" >> $LOGFILE
sqlplus userid/pwd test1.sql
.
.
.
sqlplus userid/pwd testn.sql
printf 'Script Ended at %s\n' "$( date )" >> $LOGFILE

Note that if you add set time on timing on at the top of your SQL commands,
you'll get the current and the elapsed time in your sqlplus output.

Last edited by radoulov; 03-25-2013 at 11:07 AM..
This User Gave Thanks to radoulov For This Post:
 

10 More Discussions You Might Find Interesting

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

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

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

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

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

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

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

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

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

10. 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
XmDirection(library call)												 XmDirection(library call)

NAME
XmDirection -- Data type for the direction of widget components SYNOPSIS
#include <Xm/Xm.h> DESCRIPTION
XmDirection is the data type specifying the direction in which the system displays subwidgets, children of widgets, or other visual compo- nents that are to be laid out. This data type also affects traversal order within tab groups. XmDirection is implemented as an unsigned char bit mask. The horizontal and vertical directions can be specified independent of each other. XmDirection also specifies the precedence of the horizontal and vertical directions relative to each other. For example, a value of XmRIGHT_TO_LEFT_TOP_TO_BOTTOM lays out a component horizontally from right to left first, then vertically top to bottom. XmDirection provides the following masks, each of which corresponds to a particular bit in XmDirection: o XmRIGHT_TO_LEFT_MASK o XmLEFT_TO_RIGHT_MASK o XmTOP_TO_BOTTOM_MASK o XmBOTTOM_TO_TOP_MASK o XmPRECEDENCE_HORIZ_MASK o XmPRECEDENCE_VERT_MASK In addition to the preceding single bit masks, XmDirection also provides the following multiple bit masks. These multiple bit masks are particularly useful as arguments to XmDirectionMatchPartial: o XmHORIZONTAL_MASK o XmPRECEDENCE_MASK o XmVERTICAL_MASK Motif also provides the following enumerated constants for specifying various combinations of directions: XmRIGHT_TO_LEFT_TOP_TO_BOTTOM Specifies that the components are laid out from right to left first, then top to bottom. XmLEFT_TO_RIGHT_TOP_TO_BOTTOM Specifies that the components are laid out from left to right first, then top to bottom. XmRIGHT_TO_LEFT_BOTTOM_TO_TOP Specifies that the components are laid out from right to left first, then bottom to top. XmLEFT_TO_RIGHT_BOTTOM_TO_TOP Specifies that the components are laid out from left to right first, then bottom to top. XmTOP_TO_BOTTOM_RIGHT_TO_LEFT Specifies that the components are laid out from top to bottom first, then right to left. XmTOP_TO_BOTTOM_LEFT_TO_RIGHT Specifies that the components are laid out from top to bottom first, then left to right. XmBOTTOM_TO_TOP_RIGHT_TO_LEFT Specifies that the components are laid out from bottom to top first, then right to left. XmBOTTOM_TO_TOP_LEFT_TO_RIGHT Specifies that the components are laid out from bottom to top first, then left to right. XmTOP_TO_BOTTOM Specifies that the components are laid out from top to bottom. If horizontal direction is important, do not use this constant. XmBOTTOM_TO_TOP Specifies that the components are laid out from bottom to top. If horizontal direction is important, do not use this constant. XmDEFAULT_DIRECTION Specifies that the components are laid out according to the default direction. (This constant is primarily for widget writers.) XmLEFT_TO_RIGHT Specifies that the components are laid out from left to right. If vertical direction is important, do not use this constant. XmRIGHT_TO_LEFT Specifies that the components are laid out from right to left. If vertical direction is important, do not use this constant. RELATED
XmDirectionMatch(3), XmDirectionMatchPartial(3), XmDirectionToStringDirection(3), XmString(3), XmStringDirection(3), and XmStringDirection- ToDirection(3). XmDirection(library call)
All times are GMT -4. The time now is 09:37 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy