[OPEN-ILS-GENERAL] MS SQL

[Jillian Lashmett]

Calling all database geeks!
 
PROBLEM: working with MS SQL, how do you change the definition of the day by time so that when you pull records from a certain span of days it will retrieve everything cover in those days. Or can you redefine the day?
 
EXAMPLE: You try to pull records added from Monday-Friday. The database is retreiving records created from Monday at midnight until Friday at midnight, thus not giving records that were created on Friday. 
 
Can you change this so that when you ask for Monday-Friday you can get all of the records that were created on these days?
 
I suppose one solution would be to request Monday-Saturday, but it needs to be user-friendly and not confusing to people who do not work with the database regularly. 
 
Any help would be appreciated!
 
Jillian Lashmett, Librarian I, I&R
Cumberland County Public Library & Information Center
Headquarters Library
300 Maiden Lane
Fayetteville, NC 28301-5000
Phone (910) 483-7727, x224 / Fax (910) 486-6661
jlashmet at cumberland.lib.nc.us
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://list.georgialibraries.org/pipermail/open-ils-general/attachments/20080801/efbe295d/attachment.html