Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to pass date to SQL server SP?
Top Forums Shell Programming and Scripting How to pass date to SQL server SP? Post 302926201 by DGPickett on Friday 21st of November 2014 06:42:08 PM
Old 11-21-2014
Even if you know the granularity of the local datetime, in an optimistic world you would love it to be portable. In place of worrying about the precision, which might be a very odd fraction not easily accessible by string number conversions, kiss "BETWEEN" goodbye and use "ColDate >= Date and ColDate < (Date+1day)". It has no hole. The SQL compile will just take your BETWEEN and turn it into a similar pair of predicates. There is no run time advantage. If indexed, it will search for the low value and read to the high value in the index, a range scan.

The SQL gods should have made a way to say if BETWEEN end points were included or not, like those open/dark end line point dots in math class. Many languages have these misconceived pitfalls to avoid, except when taking mindless proficiency tests to get hired.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Pass multiple variables to SQL script

I am trying to close of multiple users in an Oracle database. Each users has records in multiple tables what I need to do is use a script that call each SQL seperately passing either CLI arguments or gathered arguments from the users during run time. ## Accept variable(s) from the command line... (1 Reply)
Discussion started by: jagannatha
1 Replies

2. Shell Programming and Scripting

Pass variable to sql

Please help. I got these error. I'm try to pass variable extract from data-file.txt to sql file(select.sql). cat: cannot open select cat: cannot open * cat: cannot open from cat: cannot open user cat: cannot open where cat: cannot open name=$list; #!/bin/bash list=`sed q... (3 Replies)
Discussion started by: killboy
3 Replies

3. Shell Programming and Scripting

Pass a variable to SQL script

Hi Guys, I like to pass a variable to a sql file in a unix script.. I tried a below code.. var=200903 db2 -vf test.sql 200903 test.sql is as below. select * from db2.users where quarter = $1; Please tell me where i go wrong.. Thanks in advance, Magesh (2 Replies)
Discussion started by: mac4rfree
2 Replies

4. Shell Programming and Scripting

Pass the first date and last date of previous month

Hi All, I need to run a job every month at the beginning of the month which is scheduled through autosys, lets say on 03/01/2010. I need to pass the last month's i.e February's first_date = 02/01/2010 and last_date = 02/28/2010 as variables to a stored procedure. Can somebody please pass... (2 Replies)
Discussion started by: vigdmab
2 Replies

5. Shell Programming and Scripting

How to pass value from unix shell to sql session?

Here is the situation, I have file from which I am reading records line by line. Based upon some condition I need to pass a field from a sql session to get some data from a table. I don't have any idea how to do it.... (1 Reply)
Discussion started by: mady135
1 Replies

6. Shell Programming and Scripting

Pass perl array to SQL oracle

Hello, Could someone please suggest if there is a way to pass an perl array(pass @v_array) to SQL as in below eg : #!/usr/bin/perl @v_array = (1,2,4,5,6,8); $db_userid = 'ni71/ni711'; $bufTPO = qx{ sqlplus -s << EOF $db_userid set verify off set feedback off set... (1 Reply)
Discussion started by: arunshankar.c
1 Replies

7. Programming

pass value from Oracle sql to Korn shell

Hi All , I am trying to pass a value from sqlplus to korn shell . There is a table tab1 in Oracle that has a column userdate. I need to pass the userdate to the korn shell . This is what I am doing . VALUE=`sqlplus -silent username/password << END set pagesize 0 feedback off verify off... (14 Replies)
Discussion started by: megha2525
14 Replies

8. Shell Programming and Scripting

How to pass string into sql query?

Hi Gurus, I have a request which needs to pass string into sql. dummy code as below: sqlplus -s user/password@instance << EOF >>output.txt set echo off head off feed off pagesize 0 trimspool on linesize 1000 colsep , select emp_no, emp_name from emp where emp_no in ('a', 'b', 'c'); exit;... (4 Replies)
Discussion started by: ken6503
4 Replies

9. Shell Programming and Scripting

How to pass a shellscript variable to a sql file?

Hi, i wan't to pass a shellscript variable to a sql file. a.sql select $field from dual; the way i am calling this is through sqlplus field_name="sysdate" sqlplus -s username/password@hostname:port/servicename <<EOF @a.sql $field_name EOF (4 Replies)
Discussion started by: reignangel2003
4 Replies

10. UNIX for Advanced & Expert Users

To pass one month range in sql script

Hi Guys, i am having .sql script which inserts data from one table to another table based on date condition, i need to pass range on based on how many number of months, for e.g set timing on; whenever sqlerror exit failure; spool myscript.log append accept start_date... (7 Replies)
Discussion started by: rohit_shinez
7 Replies

LEARN ABOUT REDHAT

nwfstime

NWFSTIME(1)							     nwfstime							       NWFSTIME(1)

NAME

       nwfstime - Display / Set a NetWare server's date and time

SYNOPSIS

       nwfstime [ -h ] [ -S server ] [ -U user name ] [ -P password | -n ] [ -C ] [ -s ]

DESCRIPTION

       nwfstime displays a NetWare server's date and time. You can also set a NetWare server's date and time from the local time.

OPTIONS

       -h
	  With -h nwfstime prints a little help text.

       -S server
	  is the name of the server you want to use.

       -U user
	  user is the user name to use for login. To set the server's time, you need supervisor privileges.

       -P password
	  password  is	the password to use for login. If neither -n nor -P are given, and the user has no open connection to the server, nwfstime
	  prompts for a password.

       -n
	  -n should be given if no password is required for the login. As you need supervisor privileges for  setting  the  date  and  time,  this
	  option is probably not used very often.

       -C
	  By default, passwords are converted to uppercase before they are sent to the server, because most servers require this. You can turn off
	  this conversion by -C.

       -s
	  With -s, nwfstime sets the file server's date and time according to the local date and time.

nwfstime							    12/10/1996							       NWFSTIME(1)
All times are GMT -4. The time now is 03:22 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy